Search results for query: *

I am trying to export a parameter query into a template excel sheet. If I run the query as a select query, the code runs perfectly, however I can seem to find the right code to do this as a parameter query. What eventually I would like to do, is have this execute from a combo box on a form. The...

I want to export a ms query to an excel sheet template to a specific cell range. I would like the export results to begin at cell "a6". I have googled myself to exhaustion, trying many suggestions. The common opinion is that the following code should work, (but it does not for me)...

I have a data entry form that I want to populate the age field automatically when the (field) last name(after update event) is entered ( previously in table). I have used this dlookup: DLookup("age", "general info", "[Age] = '" & Me.Age). This bombs. I have tried some many variations I've lost...

I have a form with an unbound combo box(row source a table). When anything is clicked from the combo box it brings up data in a sub form. When I use the form from the navigation pane it works fine and correctly but when I call it from the switchboard it bombs with a run time error 3021,(no...

I have a report that simply has first name, last name and the division they are in, Either Div 1, 2 or 3, I want to total the number of people in each Division. What started off as a simple task I thought, has become a headache. I started with(for example): =Dcount("[Div]","Gen...

Good Morning Everyone, I have a text box on a form in Access 2003 that pulls in an environment variable I have established. I upgraded to Office 2007 and now that text box shows the error - #Name. I have disabled the trust relationships, however this did not solve the problem. Does anyone...

Hi everyone, My company is migrating to Microsoft Exchange Server, but many of the employees still have a pop3 account. What I would like to do without user intervention is to run the vbscript listed below in a nightly push and delete any pop3 accounts and just leave Microsoft Exchange server...

In the code below, I am importing dbf files from DB4. I recorded a macro and have made adjustments that I need so far. I created a inputbox variable spath, which pulls the file from a db4 folder with two subfolders. i.e ( c:\db4\port\111111. The spath inputbox gets the dbf from the subfolder...

Hi everyone. In the code below, I am importing dbf files from DB4. I recorded a macro and have made adjustments that I need so far. I created a inputbox variable spath, which pulls the file from a db4 folder with two subfolders. i.e ( c:\db4\port\111111. The spath inputbox gets the dbf from...

Good Morning I have the following recorded Macro, which imports a specific db4 dbf into excel. However the data source C:\db4\PORT\426950\2004 will not remain constant. The last two subfolders will constantly change. I'm trying to have an inputbox change that Data Source without success. I...

Hello all, I have the following code attached to a command button: Private Sub CommandButton1_Click() Dim Number_of_rows As Long Number_of_rows = ActiveSheet.UsedRange.Rows.Count Range("c3").Select Do Until Selection.Row = Number_of_rows + 1 If Selection.Value <>...

Hi Everyone. I need help with some Vba code. I have a spreadsheet and column E will have text of either A, B or C. After I sort the column in ascending order, I want a marcro that will find the last cell with A , Then add a blank row, then find the last cell with B and add a blank row. Can...

I have an unbound field in a report. I need to know why one of these works and the other doesnt. its the same for both Dcount() and Dsum() Any help is greatly appreciated. Heres the two things. This works: =sum([tps]<[datecleared]<[forms].[fpenetration].[begin]) This gives the #error msg...