Search results

So i have one master form (frmMainEntryForm) , that holds 2 sub forms (one being frmJobCardDataEntry) . These forms get their data from the same table. so, when [frmMainEntryForm] /or/ [frmJobCardDataEntry] field called [CheckPlotApproveAt] is changed, run a macro that will set a value in...

Hi All - hoping somebody can help... i know very little about access, its only one of the many hats i have to wear. I need to perform a function and don't know where to start really. Id prefer it to be in a query or macro rather then VBA (because i understand it better). I have a form, which...

Hi All - can somebody give me advice on calculating a date field please ? I have a form with "due date" (format: medium date). When i click in another field, i want this value to update, calculated by today's date. So my calculation needs to be Newduedate = (today date - due date) +due date...

Hi All - Not a newbie, but somebody that dips into access about once a year, and everything i learned was within 1 month about 20 years ago...so please be gentle with me :) I'm trying to edit simple font sizes on a form . Its a longstanding form/report that we have used for years. When i come...

thanks for the tip on windows updates. yes, i'm definitely the developer. i developed our access database about 15 years ago. i spend about 10 hours a year developing, in a small business such as ours, you wear many , many hats, especially when you are the onlly techy one . All self tought, 90%...

Hi All - sorry that i only post here when a i have a problem, but hoping som kind soul can give me a bit of advice. A module stopped working yesterday, one that emails customers. So, i rebooted and tried to run the MDB file and i get a popup box warning "This action is only valid for products...

Sorry, i should have posted this reply to my original posting...... i found that if i ensured that everybody was out of their own copies of the front end, and therefore the backend wasnt being used by anybody, THEN we we took a copy of a frontend and pasted it to a new PC, it worked fine. Done...

Hi All.... ive got a little coding to do, and don't really know where to start. I have the following running a report from a button. stLinkCriteria = "[account]=" & "'" & Me![Account] & "'" DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria Account is for example A01...

I have a 2000 format dbase, split FE BE, which i want to compile. I have saved it as 2003 format (using 2003 access). Compacted it, reloaded it, saved as MDE.... access creates a db1.mdb in the folder and then does nothing.... i've let it for 20 mins and it looks like it has just stopped, but no...

The frontend is (should be) exacly the same as the ones on the PC's that work. I simply copy/paste a working frontend from a good pc onto this PC, and it behaves completely differently. All are running 2003. As i said, i'm a copyer/paster of code more than a programmer, so i will google how to...

It deletes the error code, but then i get another pop up window with another "on load" or "on open" and it reports an error with every bit of coding on this form... it looks like everything is screwed on the switchboard form. But this is exactly the same frontend which works perfectly on all the...

Thanks - tried that, but now my error just changes to "the expression on load" instead of the expression on open.... however, is seems like no expressions work because when i click a button on the form to close and exit the database, i get a warning "the expression on click" so it appears...

Hi All - hoping some kind soul can help.... I have a split database. All on same network, everybody using 2003. I am a NOT a programmer, more of a cut and paster, so please excuse if i seem ignorant... Frontend works on all computers except 2. On these 2, when you try to open the dbase you get...

Thanks Selvsagt.... but this isnt a code thing, its a system config thing. I have just copied the frontend onto 4 other computers, and works perfectly on all of them. There doesnt seem anything peculiar about the problem one, but it just wont run anything.....

Thanks, but i'm pretty convinced its a config or setting rather than a programming thing. it falls at the first "on load" - if i rem that out, it then falls at the next "on open", if i rem that out it then falls at "on timer".... it basically wont do anything that is called ? But the exact same...

Hi All - hope some kind person can help a newbie.... I have a split dbase (front end / backend) which works well on the 4 or 5 systems it's installed on. It was written on 2003. I have just copied it to a new users PC, but when i try to open the dbase i get a pop up saying " the expression On...

Paul - cant get that to work in either the group footer or the report footer. if i strip it down the the simplest... ... then i get nothing displayed. If i take out the word SUM, then i get the last records value displayed.

Do you mean take all the formatting out of the individual lines in the report so it goes back to "120" "60" etc, and then just format the SUM at the bottom? i did contemplate this, but id rather have the formatted lines against each record in the report than the SUM in the footer. The SUM...

Hi All !..... hope some kind sole can help... I have a field on a report with this as its control source... ------------------- =(Format(Int([quantity]*(DLookUp("[Plot_times]","[ProductList]","[Code] = Reports![Mask_order_book]![CUST_REF]"))/60),"0") & ":" &...

Ok, this no longer crashes, but instead of the OpenReport running on the 5 items in my query result, it appears to be running on the whole database table of thousands... Private Sub Command18_Click() On Error GoTo Export_Invoice_Err Dim rstJobs Dim dbs As DAO.Recordset '...