Search results

Thanks Namliam, but it appears that it's not those line. Ive rem'd out those DoCmd lines so all the script does is loop through the record set, and it still bombs out. The open query works, because the table displays on screen, but then it jumps straight to 'problems"... My query is an append...

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

Im afraid i'm not very good with VBA - ... Below is working on one record only, so i need to just create a loop... it's the loop i cant quite understand. My script that hangs off a button is this (cropped):- DoCmd.OpenQuery "NewCsvExport", acViewNormal, acReadOnly DoCmd.Close...

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 structured it uisng Iif instead of my Likes (hanks to pat; suggestion), and have it all working lovely know.! Thanks very much for everyones reply... Here is the final code... SELECT sum(IIf(Left([jb-2001].NOTES,4) Like "C??H" And...

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

Sorry, still having grouble actually calling the module? It returns "undefined function 'getSquareArea' in expression ".... which to me sounds like it can't find the module ? My query is ... Expr1: getSquareArea ([NOTES]) and my module is Function getSquareArea(dimensiontext) ' takes...

Thanks Plog..... this is probably a dumbass question, but the first line in the module... where/what does (dimensiontext) represent? Function getSquareArea(dimensiontext)

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 Shadow - no, it's not that, but thanks for the reply....

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

Well said !!! My sentiments exactly ! I have an Access database that does exactly everything that we need at the moment. It's perfect for our needs. I spent ages fine tuning it - if anyone assk me for any information or new reports, BANG - it's done in an instant. And then the MD had a demo...

thanks for the feedback guys... i'm persevering with ACT at the moment. I found the sync very quick and effective, but it's really just a contact management dbase and couldn;t really be used for other stuff.

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

Dave, from one Lancashire lad to another - that meant nothing to me. Flew straight over the old noggin. Told you i was a newbie! I started off with a SETVALUE in a macro, which did this... item: [Forms]![Job Entry]![job_history] expression: Environ("username") & " , ORDER ENTERED " But...

maybe i've made this sound more complicated than it is.... all i actually want to do, is by using a line within a macro, update a field with the date/time/ environ(username) and a quick one line of text. I can't do it by SETVALUE, because it doesn;t like "environ' in the expression, and i...

that doesn;t work, because i get "compile error - expected variable or proceedure, not module". It appears to not like field names in a function module ?

Actually, all i'm lookinng to do is run the code from within a macro. I just can;t work out how to do it, because it will only let me run functions and i don;'t think what i have is a function. I tried this in a module, but it doesn;t like the last couple of lines...