Search results

Got it to work using a variable in the qry criteria field. When I attempted before I did not have a public variable to pass the info to. I just tried a function and then pass then criteria to that function. Thanks for the help. If there is a better way to work this please let me know.

failing code. If the form is not opened by one of the 3 ways no data is shown. (which is fine I only want there to be 3 ways to use the form. there will be no other way to access the form other than the 3 ways.) will OpenArgs let me select which qry to use as the data source for the form...

lets see if i can explain this correctly. If there is a better way please point that out to me also. Thanks. I have multiple forms that do just about the same thing. I want to clean up the database so I am going to use one form and switches to vary the data or displays if needed. the form...

you need a = after forms!myform!myfield instead of a , In 2007 i had an issue with just using the Environ("computername") I had to change it to vba.environ("computername"). so your comand should look like this: forms!myform!myfield = Environ("Computername")

Okay got it now. removed: tmpLoc = me!txtCustFilePath changed: FROM tbl126acftview IN tmpLoc" to IN " & " ' " & me!txtcustfilepath.value & " ' " & ";" thanks

namliam, That would work if the thumb drive always received the same drive letter. Or if it was the same thumb drive all the time. was trying the following code: Dim tmpLoc As String Dim strSql If IsNull(txtCustFilePath) Then MsgBox ("Requried file path(s) are missing.")...

okay got it i think. did some more searching and found the in command will do what i want for the query with another db. used: SELECT * FROM MYTBL IN 'C:\DATABASE.MDB';

Didn't think of that. i would just leave the thumb drive in and then run the querys and when done let the user know to remove the thumbdrive. How do i reference the db on the thumbdrive in a query? or do i just import the tables to the frontend and then do the querys to update then delete the...

Good day all, I have a sql2000 database on one network and i need data copied an access database which is on another network. the networks can't be connected together. This is what i have: I created a db that pulls the info out of sql and puts it in access. (this is done on the command line...

Thanks lagbolt, figured it out before I saw your post. This seems to work: =IIf([tmpyrssvc]<=4,[tmpyrssvc],IIf([tmpyrssvc]>DMax("years","tblpay","[grade]=forms!frmpersonnel!tmpgrade"),DMax("years","tblpay","[grade]=forms!frmpersonnel!tmpgrade"),IIf([tmpeven]=1,[tmpyrssvc]-1,[tmpyrssvc])))

try this code: =IIf([GRT]<=500,333000,333000+(2500*500)+(([GRT]-3000)*333)) made correction

Not sure how to do a search on this one so here it is. I have a paytable that has years and dollar amounts to each year. Years 1-4 are consecutive and after 4 they increase by 2 up to year 26. Year 26 is the max amount you can get. ie. 2=20.00, 3=22.00, 4=26.00, 6 = 30.00, 8 = 35.60, 10=...

I am trying to run an update query and i get the following error: The parameter values are too large. The total length of all the values entered for the parameters cannot exceed 1,024 characters. The field is a memo field and it is just updating the other related records memo field also...

The data is normalized in tblPids and in tblNSN. tblhandreceipt is a combined table that contains combinations of pid's and nsn's. Not every pid in tblpids is in tblhandreceipt. I wanted to add another nsn to tblhandreceipt but I only want to add it to the pids that are already in tblhandreceipt.

I am trying to add another record to a table. Pid and nsn are the keys. the table has 70 unique pid's. I need to add another nsn to each of the pid's. I tried the following code but no go: Set db = CurrentDb Set rst1 = db.OpenRecordset("tblHandReceipt") Set rst2 =...

Okay i'm dumb. Got it to work. instead of trying to sort on the qry that the report is based on or in the SQL code in the group heading print event. I put the field i want to order by in the ORDER BY field on the data tab of the reports propertys and of course it worked. So in this case the...

sample db here is the sample db. one button opens the working report(it's not sorted on nsn or item.) the second button is using the code that is trying to sort on nsn. Thanks,

I did hard code the pid in QBE. I will post a sample db. Thanks for the help.

using QBE i get the following SQL: SELECT Count(qryrptflighthr.PID) AS HR, qryrptflighthr.NSN, qryrptflighthr.ITEM, qryrptflighthr.UI, qryrptflighthr.ISSUEDQTY, qryrptflighthr.PID FROM qryrptflighthr WHERE (qryrptflighthr.PID) = '" & Me!PID & "' GROUP BY qryrptflighthr.NSN, qryrptflighthr.ITEM...

this code: Set rsHR = Cdb.OpenRecordset("Select NSN, ITEM, UI, ISSUEDQTY, PID, Count([HRID])as HR FROM qryrptflighthr GROUP BY NSN, ITEM, UI, ISSUEDQTY WHERE PID = '" & Me!PID & "'") gives me syntax error (missing operator) in qry expression 'issuedqty where pid=jb4623" found ref. to aggregate...