Search results

Try .NoMatch

You can do it the nice and easy way and reference the control on the form: In the criteria put: [forms]![Form_Name_Here]![Combo_Box_Name_Here] Then close the form . . . OR if you really want to populate the variable System: 1. Rename it strSystem 2. On the On_Click event of the combox box...

I have looked around forum but cannot find any info on this. I'm basically upgrading from MS Access Version 2 ( . . I know!) to MS Access 2003. Here's what I'm trying to do: 1. Loop through a bunch of files (MS Access Version 2 *.mdbs) in a Sorce Folder and capture names in an Array. 2. Create...

Fully qualify AviFile. i.e. AviFile = "C:\Users\Tyler\Desktop\produce.avi"

A couple of things: 1. Copy and paste the value of strTemp (from the 'Immediate Window') in the Start\Run box. Check if the file opens okay. If not then resolve file reference. 2. Does this server allow your application to connect to it? - Should talk to your helpdesk/Network guys.

Two options: 1.a Use the TransferText command. Can set options so you can miss NULL values. 1.b. Append data (WHERE NOT NULL) 2.a Open file 2.b Loop through until EOF and insert records in table (WHERE NOT NULL) There should be lots of info on the above in these forums.

Look at the design of your table. Look at the 'Lookup' tab at the bottom left of your screen (next to the General tab). Display Control: List Box Row Source Type: Value List Row Source: 1;2;4;etc;etc Good Luck.

What happened when running the query without this column but searching for Is Null results? Or using this column and setting a criteria Not Is Null for the column [Award dtd]

In what way is it not working? Does nothing happen . . error message? You should put this in the on Click event anyway and capture the error not step over it. Where's the connection & recordset objects? Plus, call me crazy, but in the WHERE clause they are the same data types?? I.e You're not...

Look at DateDiff function in the help for the time differences. Thus for example in a new column in your query you can type: DifferenceInDays: DateDiff("d",[Table 1 Name].[DateField Name], [Table 2 Name].[DateField Name])

What MS Access version are you running this in? Plus I would remove this field and just check for Null values in the [Award Dtd] field first.

Is this what you are trying to do? . . For each Customer For each Profile_Class Add all the values in fields starting with the letters 'HH' Update a temporary table/audit table Next Profile_Class Next Customer

You should highlight DLookup and press F1. This will show you the correct syntax for DLookup function. Plus, are the two values you are using in the WHERE clause numeric? Anyway, try this: PIHP_CMHSP_MHP.Value = DLookup("[PIHP-CMHSP-MHP]", "PIHP", "[countycd] = " & Combo2.Value & " and [PFcd]...

Looks fine, apart from dropping the '_' FYear: Year([Award Dtd])-IIf([Award Dtd]< _ DateSerial(Year([Award dtd]),10,01),1,0) to become: FYear: Year([Award Dtd])-IIf([Award Dtd]<DateSerial(Year([Award dtd]),10,01),1,0) What is the error?

Can you expand on what you are trying to do please.

1. At present, what areguments are you passing when Opening the Report. 2. What version of access are you using?

All I am trying to do is import a Report from one MS Access db into another. When I do this I get the following error: "Path/File access error :"\VB4.tmp" Press okay and then I get this . . . "Name conflicts with existing module, project, or object librabry. Press okay and then I get this . ...

What version of Access are you developing in?

What are these 'Run Time' files you need to install? With VB you can package up all the installation files are et Voila! So what do I need to 'package up' and how??

Hi there! From the forums I've seen this error occur on forms. Unfortunately this is happening in a report! Worth noting that the db was converted from Acc 97 to 2003. Steps so far I've tried: 1. Created a new Report with all new controls, then referenced the data source from the control not...