Search results

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...

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...

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...

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...

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...

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") & ":" &...

Hoping some kind hearted sole can help me....(i'm a novice). I have the following code running from a button on a form, which uses "NewCsvExport" query as its record source. I want to open and print a report for each record in the query. When running, i just bomb straight out to 'on error'. I...

Hi All - hoping some kind soul can point me in the right direction. Uing Acess 2003 across the company, i am responsible and have bodged together over the years a production control database. I spend 10 mins a week tinkering, so very much a newbie and i'm learning as i go along. Main problem i...

Hi All - i'm not very good at the basic structuring of queries/sql.... i want to check for 2 conditions, and do some maths depending on the condition. So, in my head, i'd just use an AND/OR condition, but it doesn;t work. I'll not paste the complicated code because i'm looking for an overview...

Hi All - i think this is a simple enough thing to do, but just can't work it out in my head.. I have some invoices in a dbase. I want to build a query where customer = widgets PLC, >Date = 1/1/11 < 1/2/11, and where item 1 OR item2 OR item 3 or Item 4 contains "nails" It's the querying more...

Hi All - i would greatly appreciate some help with a query... I have a text field, 2 samples here below... CSLS7_06- SL Chrome Super High Res, 7" x 0.060" CSLS12_09- SL Chrome Super High Res, 7" x 0.090" This is a product, square plate with a thickness. I need to work out the square inch of...

Hi All - got a very strange problem here, but i'm unsure if it's MS access problem or not. I have about 10 reports, all with headers. The header is a letterhead, with a logo in top left corner. In Access print preview, everything looks fine, but the logo fails to actually print - whther to a...

Hi All - hoping smebody can kindly give me some hints or help.... Background info: I'm a basic / intermediary access user. I very rarely use code (when i do, i tend to copy/paste from snippets i find). Mydbase has evolved over a few years, but is probably very poorly organised. Help required...

Hi All - i have access 2007 for contact dbase management. We have 8 users around the country, who all sync once a day (VPN). I've been asked to change to ACT - the reason behind this, is email history. Currently, we have to remember to cut/paste any emails sent to clients (and received) into...

Hi All - hoping someone can help me with the structure of some coding. I do dbase programming every 6 months, for a few minutes a time, and have never really learned how to structure things correctly. I have a button on a form which runs a macro. That macro does various tasks. I have some code...

Hi All - i'm probably going to use the wrong terminoligy here - so forgive me... I have a union query that works great. It shows me all of the records that contain a certain product code beginning with "CS". The product is contained in a text field (actually 8 fields for 8 rows of the invoice)...

i have a form with very basic fields on them. Nothing calculated, nothing strange. All field values are from the same basic table. Sometimes (havn't been able to pinpoint it yet), when i search for a string, either using CTRL-F or even a search button i added, the "find" takes me to a required...