Search results

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 know this is an old posting, but hoping someone can still help with it... All i want to do is set the value of a field to the user name or computer name of the person that has the database open. This is just to track who is doing what. I don;t need anything clever or foolproof, just...

Great - works a treat ! Thanks Trevor.

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

Thanks Ray - but most of the users use CRT-F to find/search, so that makes it kinds trikky. Anyone else have a take on this? I'd appreciate any clues as to why it's not working ?

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

deleted this post

I know that 'And If' isn't good syntax, but can't work out which way to lay this query out. It's a simple query that reports back stuff from yesterday. However, on a Monday this isn;t relevant because i actually need Friday data. So, somehwere in this code i need .... if (weekday(date) = 2...

Thanks guys....the 'exit sub' makes sense. That's whay it was always processing the error sub ! That's cleared that one up. Also, i've added a break into the code, and stepped through, and found the reason that the query wasn;t running - obviously there is some error in programming and the...

Thanks for the feedback, but a 'do events' doesn;t change anything. Also, how do i step through it? If i'm in the private sub, then debug/f8 doesn't step through anything?

The query is an update query.....

Hi all - i've copied this code from somewhere (can't rememebr, but may even have been this forum?) and then butchered it to fit my needs. I'm completely new to VBA coding, and can tell that it's not structured correctly, but can't seem to get it to work. Private Sub Command18_Click() On Error...

Hi All - soemthing very strange, and probably very simple (=stupid). I modified an existing report, deleted all of the details/headers etc, changed the SQL query etc etc Now, when i run the report, it asks me to enter 2 parameter values - these basically are field names that used to be on the...

I don't think so, because i use exactly the same coding on a couple of other forms (so DoCmd AcClose AcForm) instead of Acreport. It's just the report one that crashes? I'll give it a go anyway..

Hi All - i'm a newby to VBA, so please be gentle on me ...:) The following code crashes the database at this line in both situations:- DoCmd.Close acReport, "Month_rp", acSaveNo i'm trying to close the report." It's a very very basic password check, and the code is assigned to 'on open' of...

Hi dave - Sorry, somewhat of a newby and not uptodate with the terminology. I'm using access 2007. I have a report with an underlying query. I don't understand "visual queries" or how to put them in series?

.... sorry, i meant 'group by' and not 'order by'. I't looks like any other aggregate that i try (for example FIRST or LAST) gives me this error....

Hi George, Thanks for the feedback. My code was highly simplified from the actual code, however when i tried this method on both my existing code AND the highly simplified one, i get the following:- "reserved error -1524". I've googled that, but can't find anything that really means...

Hi All, I'm getting the 'not part of aggregate function' error on a SQl. After looking through previous posts, i can see that it's because i'm grouping some of my fields (using SUM) but not others. The trouble i have, is i don't understand what i have to do with them in the SQL. I have a...

My workaround at the moment is to constantly copy/paste TIDY code to notepad, which i can then copy/paste back to the SQL when i need to tweak it. Sure is annoying though !