Search results for query: *

no network, just a laptop. doesn't make sense to me Brian

recently my ms access wont open. not a single db. but access itself. Ive tried opening and making a new db and ive tried transferring existing dbs to another machine where they all work fine. i've removed ms office from the computer and reinstalled several times with the same results...

i'll try it out and repost when i'm done. thanks for the effort. if it wasn't for all the data in the current tables, I'd try to attach the file for viewing. I think that would be easier than trying to explain some of this. Brian

tablesavedinfo Brian

error... cannot lock table etc. etc. (same as above.) something i've noticed...if i by pass the form, open the report in preview, the latest record is now what shows in the window w/ a header as it should be. however if i select the multipage view, i see continuous reports... record 63, 1...

DoCmd.OpenReport "rprtmain", acViewPreview, ,.... syntax error code in the Button's OnClick event....w/ where stmnt removed.. Private Sub Command100_Click() DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 DoCmd.OpenReport "rprtmain", acViewPreview, , End Sub Brian

hi, it was set to no locks. i changed it to edited records. but still get the same error Brian

I press the button when I'm done the data entry, yes. I added the code and this error still comes up... the db engine could not lock the table tblsavedinfo because it is already in use by another person or process Brian

my form and my report, both have the same recordsource. when i press the button i get an error saying the recordsource is being used by the form. Brian

I'm sure its something i'm doing wrong because I've taken this same code out of quite a few posts in the last few days and can't figure it out. thanks for the assistance. # 1- number #2- tblsavedinfo is the table in the recordsource box. "id" is the pk #3- please re phrase question Brian

gingerR...compile error...method or data not found. Brian

hkaing...run time error... extra ) in query expression '(primaryID)' DoCmd.OpenReport "rprtmain", acViewPreview, , "PrimaryID=" & PrimaryID Brian

Hi i want to add a button to my form that will print a report of the the current record. 1 record = 1 day in db. how do I set this up so that when the button is pressed the current record will be previewed and then printed with a header. right now the print button wants to print all records...

hkaing79, What you suggest, is what I've used in that instance and it works fine. but in another combo (which I filter from, the row source code is the following SELECT tblsavedinfo.ID, tblsavedinfo.reportdate, tblsavedinfo.[penned by] FROM tblsavedinfo; this displays the proper rows of the...

Hi, When I go into my tables of saved data from a form, I've noticed some of the columns w/ stored values have in them the data I typed on the form, and some (which correspond w/ the forms combo boxes) are storing row numbers from my table, not the selection itself. My problem is, when...

no, i've tried changing the column# (tried 0-7) Brian

let me rephrase...ID is set to zero, job # is set to 1" but when the list opens it identifies the id instead of job # job#= 5555 id=1....list should display 5555 but shows 1 Brian

one more quick question phv, I have a combobox used for filtering a form, using the above referanced combo box data. when i open the filter combo, I see the private id, not the info in the table. is there a quick fix for this? Brian

Perfect! Thank You Brian

SELECT tbllistinfo.ID, tbllistinfo.[Job#Slist] FROM tbllistinfo ORDER BY tbllistinfo.[Job#Slist] DESC; Brian