Threads Replies Last Post 225 Pages: <<  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  >>   Using Combo Boxes As control sources for SQL views and stored proc My database was just moved onto an SQL server, and I have very little experience with SQL servers. Before the switch, I used combo boxes on a form to narrow data in a query. These combo boxes could be changed by the user, and they could then view a report based on their selections in the combo boxes. Since the database has been moved to the SQL server, the queries that used the combo ... 3 06.09.2006 15:14:02 Pass variable to SQL Server How can I pass a variable to a stored procedure in SQL Server? I want the variable to come from a field in an access form. -- Billy Rogers Dallas,TX Currently Using Office 2000 and Office 2003... 2 06.09.2006 14:47:53 Programmatically create an option group button Is it possible to create an option group button? I would like to create option group buttons for each catagory in a table on "Open Form". I can move them, change their characteristics, but I don't see how to create one. Thanks in advance.... 2 06.09.2006 14:30:45 Copy last 12 rows after filtering I need to filter some data based on a specific field. However, I need to copy only the last 12 rows of the filtered data and paste it on another worksheet. I know how to do all of this in VB except for determining how to only capture the last 12 rows of the filtered data. I tried getting the last column of data and setting the copy range from [(last row - 12) to last row] but this gets t... 2 06.09.2006 14:10:02 VB widow open's after unlock of computer During the process of working on an access file I will lock my computer (using Ctr+Alt+Del and selecting lock) and when I return and unlock my computer Access will open the Visual Basic window, which was not open beforehand, right after the computer is unlocked. I can't find anything on the KB nor on the access forums has anyone else epxerinced this?... 2 06.09.2006 13:47:36 form pop up I have the following code what I want is for a form to pop up before the code runs then close when the code is done running. It does pop up however it never closes. Private Sub Command25_Click() DoCmd.SetWarnings False DoCmd.OpenForm "frmUpdateDBMsg" CurrentDb.QueryDefs("qurinmtinfoAppend").Execute dbFailOnError CurrentDb.TableDefs.Refresh DoEvents CurrentDb.QueryDefs("qurOldInmates"... 5 06.09.2006 12:14:02 Time difference I have a table that has a start time, end time, and call length. Whats the best way to have access fill in the [call length] feild with the elapsed time? The time will NEVER start on one day and end on another. Longest all i have ever sense is about an hour. ... 4 06.09.2006 07:21:49 Reuse error handling routines with Form.Dirty = False Hi group, In my unbound form I have a tabbed control with bound subforms in it. When the user adds a new or edits an existing record in one of the subforms and then puts the focus on something else (next record, button in main form, etc.) the record first saves and then the command the user invoked will start. However, when the user in stead selects some menu item, the modified reco... 4 06.09.2006 07:09:10 How to cancel a form's close properly after subform's BeforeUpdate cancels Hi group, Just to share after getting some nice advice from this group. My situation: * I use Access 2003 (Dutch edition if that's of any use) * I have a main form with a tab control on it which in turn holds subforms * The tab control is named "oTab" * The subforms are called "oFormX" where X is the number of the tab they're on (1 based) * The main form is unbound, the subforms's for... 1 06.09.2006 06:38:37 Attachment with followhyperlink mailto Hi all, I have found out that one can open the users mailbox and prepare a mail to send with code like this: Dim sendstring As String If Nz(Me.[envoyera], "") <> "" Then sendstring = "mailto:" & Me.[envoyera].Value If Nz(Me!envoyerCC, "") <> "" Then sendstring = sendstring & "?CC=" & Me!envoyerCC.Value End If If Nz(Me!envoyerB... 3 06.09.2006 06:28:02 Module or Class Module I have a database which is for call logging for the IT dept, there is one form for entering the call and this form is duplicated 8 times, one for each of the sites that we manage. It all works fine except there is a fair bit of visual basic code which is then duplicated 8 times and it slows down the whole database. Is there a way of writing the code once and having an active form call on... 5 06.09.2006 06:08:30 Programming language in Access 2007 What programming language is embedded in Access 2007? Is it still VBA or will it be possible to use VisualBasic.Net? -- Ken McLean... 2 06.09.2006 03:46:08 Word 2003 (was 2000) Mailmerge Failure in Access 2003 VBA The following code has worked perfectly (it was derived from macros) until Word was upgraded to 2003. Set oApp = CreateObject("Word.Application") ' With oApp ' .Visible = True ' .Activate ' .WindowState = wdWindowStateMaximize ' End With oApp.ChangeFileOpenDirectory SourceDocsDirectory oApp.Documents.Open Filena... 2 05.09.2006 23:25:34 Insert a record and another record does not work I have form that a user enters data. The users clicks the command button and inserts the record in a table in the database. After the insert is complete, the form is clear to enter more data. When the user enters more data, he will click on the command button again. He does not receive any errors. When I check the table to verify the records are there, only the first record is there. Th... 8 05.09.2006 18:25:47 /Cmd and Server 2003 Hi, all! Have been successfully using an Access 2002 database to run a manual update of customer data on my workstation. I called it by using a shortcut containing /cmd "XXX" as a parameter and by using "myStr = Command()" to retrieve the parameter. It worked great. We recently installed a new server running Server 2003 with Access 2002 installed. We copied the database (also 20... 3 05.09.2006 18:10:02 change the mail merge request I have a document I use every month. I use a field to establish each months letters. "Renewal Month" is the field. Each month is numbered 1-12 and I mail out letters to individuals one month in advance. I change the month, but keep getting the old list. I have tried everything to change the month and it will not take.... 2 05.09.2006 17:57:03 HELP We are looking to buy databases in the following industries * Pharmacy * Poker * Bingo * Casino * Sportsbook * Backgammon We will pay top $ for data Please contact albert_constantin@walla.com Thank you, Albert ... 9 05.09.2006 17:05:24 Update query: Data type mismatch Here's my code: Do While currentDate <= tempFinish strSQL = "UPDATE Forecast SET Forecast.totalValue = ""totalValue"" +" & dailyValue & " WHERE (((Forecast.calDate)=#" & Format(currentDate, "mm/dd/yyyy") & "#));" cmd.CommandText = strSQL Debug.Print strSQL cmd.Execute currentDate = currentDate + 1 Loop And here's the strSQL output ... 3 05.09.2006 15:50:02 Code using Dates Given a startDate, and a finishDate, how can I: a) Find out the number of days in each month between those dates. ie 28/09/06 to 02/11/06 would have 3 days in September, 31 in October, and 2 in November. b) Loop for each month. Ie, with the above dates, the loop would run 3 times (Sept, Oct, Nov). c) Alternative to all the above. Count the number of days between the two dates. Loo... 2 05.09.2006 15:01:02 Conditional Replace Need to find a way to replace a blank field with characters. Any field that has 'no data' to contain 'UK' Had a question about this here a while ago but it has been deleted... Thanks SGC ... 8 05.09.2006 09:46:32 ms access quits I have an ms access table with some 400 records. Ms access aborts when I open this table in datasheet mode. Opening the table woth a form works fine albeit slow. The same database and table perform fine on the laptop of a fellow worker. Another fellow worker has the same problem I have. Even when I create a new database with a new table performance is abismal. When I open the empty t... 2 05.09.2006 08:10:02 Dates of birthday Hello I have form in him are fed friends with specifications of people and birthdate I want that in their birthday of the date will color red or will jump me sign Thank you -- dov... 2 05.09.2006 07:04:23 Check connectivity to network drive I have another probably simple question. I need to check to see if a connection to a network drive exsists before I execute some code. If the drive does not exsist, I need to terminate the proceedure, with a simple msgbox. Is there a way to do this? My network drive is \\jupiter\output Any ideas? Thanks. ... 3 04.09.2006 20:51:58 Excel In Access, I use several Excel file which are linked to my Database. In a macro, I have to make sure that these Excel files are closed before running it. How do I check some Excel files are closed and stop the macro if opened ? Thanks in advance Serge... 2 04.09.2006 20:04:59 Arrow keys Hello. I have a form with a treeview control. I'd like, if possible, to use the arrow keys to navigate through the nodes. Is this possible ? Thanks.... 4 04.09.2006 15:51:39 225 Pages: <<  4  5  6  7  8  9  10  11  12  13  14  15  16  17  18  19  20  21  22  23  24  25  26  27  28  29  30  31  32  33  >>