Search results

usu you get the #DELETE when another user deletes the records so the other user see this msg. a refresh usu fixes it. does user have permission to copy files to target folder?

On what line? what about REFERENCES?

IS there code that runs at startup? hold SHIFT KEY ,then open the db.

did you put a stop point at the 1st line, then step thru the code (F8) to see where the stall is? prob at the: Set rst =. sometimes is a REFERENCE that wont quite work. vbe (alt-F11) , tools, references. are there any checked, but say MISSING?

= "\\SERVER\Billing\" & [Mdid] & format(date(),"yymmdd") & ".pdf"

make a form, say frmRpts. On it have 2 text boxes for dates: txtStartDate, txtEndDate. The user selects a begin and end dates put some buttons to auto fill in the date boxes for quick date ranges: weekly, monthly. The base query Q1, that reads the boxs for criteria... select * from table...

pasting into the queries will prevent errors, 2 keystrokes each, copy, paste. 50 queries will not fill up the db.

have the form open the pdf into a web browser.

paste each of them into queries, put all queries into a macro, run macro.

downloads do that.

did you use BUILDER to get the correct control path? misspellings can happen if you type it manually or the field doesn't exist.

the entry form would have a button to open the report. The report query would look on the form for the record key , say: txtID qry: select * from table where [id]=forms!fMyForm!txtID then the report would open on the record currently shown: docmd.OpenReport "rRpt",acViewPreview

instead of param query, make a continuous form that shows all data, put UNBOUND controls on the header area for it to filter the data, user then clicks FIND btn which checks the controls on what to filter: Public Sub btnFIND_Click() Dim sSql As String, sWhere As String sWhere = "1=1"...

tIngredients tbl --------- IngredID , autonum IngredientName tTry tbl --------- *TryID (text or numeric depending how you want to use the Try format) TryDate other detail fields etc tTryIngredients tbl --------------- *TryID *IngredID *=keyed make a form for data entry for fTry: frmTry...

Pivot is very hard to do in report since it keep changing. Tho you CAN make a report table that has all columns, then make an append query to add records to the report table, (fills the existing columns) then report on the report table, since all columns are there. or just always show pivot...

this Find screen would count the recs having given name. if 0 exist, open the detail in dataentry mode if 1 exists, the only exising rec, open that rec in detail form if > 1 exists, open a LIST view of all recs that match, then user can choose the correct 1 and open detail from there...

yes, thats for outlook. or theres also : docmd.SendObject acSendReport ,"rMyReport",acFormatPDF,sTo, ,,sSubj, sMsgBody

Does the email code use .SEND command? Once sent, it should release.