Search results

You need to do something like this: SELECT Owner, Location, Type, Count(FruitID) as CountOfFruitID, Count([FruitID) / DLookup("CountOfOwner","qryOwnerCounts","Owner='" & [Owner] & "'") as Allocation FROM YourTable GROUP BY Owner, Location, Type Then create a separate query called...

.mdw was Microsoft Access workgroup security in versions prior to Access 2007. So this allowed you to create permissions on objects and the database based on group membership. So a properly secured database would not be accessible without the .mdw file (workgroup security file). Microsoft...

Your dlookup is not parsing out the WHERE part of the argument. So I think your syntax needs to be as below: If tblWIPcomments_ord is a numeric field: =DLookUp("[tblSuper_Name]","qry_allWIP","[tblZCSCOST_ord] = " & [tblWIPcomments_ord]) and if it's a text field...

Your modules should be listed and show in the Navigation Pane. But this depends on how you have your Navigation Pane set up. I personally turn off all dates and detail so I can see a simple list of objects. I also group the navigation pane by Object Type so it should show Forms> Queries >...

Are you naming your fields like tables? It appears you are not referring to your actual field names in the dlookup function. tblZCSCost_ord seems like a table name to me.

You would probably have to do it on the Report Detail Format or Print event to check each row as the report is generated.

Can you post your error?

I would check the number of rows imported vs the number of rows in Excel. Also, Acces generates an ImportErrors table. You should check to see if it created an ImportErrors table for your last import. This table should give you the row in Excel that failed and the column name.

Try this instead from Access VBA: OutputSheet.Range("B1")= "Hello world."

You need to check your Excel Data against the Access table. This error means you have values from Excel going into fields in Access that don't allow that value. For example if your access table has a field that does not allow nulls, but Excel has blank values this will produce an error. Or, if...

Absolutely. You should not need 20 different tables if they are all the same structure. Definitely set up a test environment before you change anything. Are you using an .mdw file for the security? If user is only in record for 10 seconds then you would have to be sure the record gets...

Cool! Glad you got that working. Also, I learned something today. I have never used the Recordset property in that fashion before so you taught me something!

It's not going to work the way you are trying to do it. The code will only run for the current record in the form. The only way you will be able to do it in the subform is by looping through every record in the subform in VBA and checking. Sorry, I know I asked this previously, but the VERIFY...

Is the verify button on your subform or main form? Try Verify = true

Are you using a main form and then your continuous form records are in your subform?

Dim yourfilePath as string yourfilePath = "N:\DRAWINGS\" & [Drawing#] & "-01_" & [DwgRev] & ".dwg" If Len(Dir(yourfilepath)) > 0 Then 'file exists End If

Here is what you need to check if file exists: If Len(Dir(yourfilepath)) > 0 Then 'file exists End If

what version of Access are you running?

when you open the main form do you need to validate ALL records? Or do you need to only validate one at a time? If that is the case you should put your code in the onCurrent event of the record. The code will run only when user selects that record.

What's varfieldname? This won't work. You can't set visible property of a variable. Also, i is not the value of your listbox. that is the number. To get the value of your listbox you would need to do this: varFieldName = Me.[ListSymbolSelect].ItemData(Item)...