Search results

Hi all. I've got a form... I choose a selection from a combo box. The selected record determines what needs to go in a text box and another combo. I keep getting this error when I try to set focus on the textbox. How do I correct this? "You must save the field before you execute the...

Hi all. I wrote a query and saved it. It counts records. When I click on the query I get 3074 as the result. I wrote a function that calls the query, but the function returns 0. Here is the code. It is a carbon copy of another function that does exactly the same thing and works perfectly...

Hey all. I've got a parameter query that feeds a report. I'd like to call the report in code and feed it the parameter. I thought the following code would do it, but I still get the parameter prompt [Enter Vendor Number]. Any suggestions? PB Text0.SetFocus myVendorNum =...

Hello all. The help files in Access seem to be leading me down the wrong path. I am trying to set up User Level Security. I want a SuperUser that can log in and do whatever and a read-only set of users. The help files keep setting up a universal password that asks for the admin password on...

I am trying to import a spreadsheet to a table. On my computer, it works fine. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Data", myFileName, True True being the "HasFieldNames" parameter I copy this file onto another machine and it no longer assigns field names. It imports...

Hello all, I have 2 tables. PO and Repair_Tag PO table PO(txt)....Vendor(num).......UserCode(txt)......etc Repair_Tag table Repair_Tag(txt)......UserCode(txt)..........Vendor(num).......PO(txt)........etc My question is: Is it possible to make the field PO in Repair_Tag a lookup value that...

Gui Using the import wizard is a GUI action. I'm doing this in code that needs to be repeatable. action: Go get the file, Bring it in. Report on the data. end action: Any suggestions on what may be interfering? Private Sub Command2_Click() On Error GoTo Err_Command2_Click...

I am trying to import a spreadsheet to a table. On my computer, it works fine. DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "Data", myFileName, True True being the "HasFieldNames" parameter I copy this file onto another machine and it no longer assigns field names. It imports...

Hi all, I have a db that autolaunches a form at start up. I want to deactivate it but when I go to 'Tools' --> 'Startup' , the 'Display Form/Page' drop down box says 'None'. Where else can I look for autolaunch commands so I can turn it off? Thanks everyone. PB

Good day. All. I have a recordset that I pull values from. like myValue = rst.fields("Field1") I loop through the recordset and sometimes the field is empty (I think) and it throws an error. "Invalid use of null!" Since I need to obviously keep running the program instead of crashing, how...

Hello, Everyone. I've got a form set up in 'Tabular' mode. I would like to step through a particular column of text boxes and test the contents but don't know what to loop through. The text box I'm using is called Complaint. Something like.... do while more Complaint myVariable =...

Hi all. I'm pulling lots of data from many tables and there is a field that I need to sum up instead of pull each entry. The query is large but I don't think the issue is with the contents of the query, it's with my knowledge of how to sum up certain fields in multiple table queries, so please...

Hi all. What reference do I need to include for the mid() function. I wrote a great process on my machine but it crashes on the requestor's machine due to the mid() function not being found. Anyone know the reference? Have a suggestion? Thanks PB

Hi all. I've got a text file that I import into a table. It typically has lots of garbage in it that populates an automatic importErrors table. I know that this importErrors table will always start with "QRPT" and then be followed by a different set of digits each time. Is there a 'delete...

Thanks Syntax, Syntax, Syntax. HeHe PB

Hi all. I have a query that returns lots of data. I assign the recordset fields to variables. Some of the fields come back null (some date fields). I need to know which ones are null so I can assign something to them. I tried this. if myDateVariable is null then do this code end if it...

Crosspost Sorry about the cross/double post, namliam. Not sure what happened. PB

Thank you Ah, yes it is Oracle. Thank you. Makes sense. PB

Unfamiliar query symbo... Hello all, I ran across this 'Where clause' and didn't recognize one of the symbols WHERE MAXIMO.V_INVENTORY.ITEMNUM (+) = MAXIMO.V_POLINE.ITEMNUM What is (+)= doing? Thanks all PB

Hello all, I ran across this 'Where clause' and didn't recognize one of the symbols WHERE MAXIMO.V_INVENTORY.ITEMNUM (+) = MAXIMO.V_POLINE.ITEMNUM What is (+)= doing? Thanks all PB