Search results

Hi guys, finally back from a restful break... here is a very simplified example of what I'm talking about (I shortened it to 4 queries).... Try running the macro 'Lookup'...used to work without a hitch, now it just refuses to.... Thanks for the help... :confused: [Edit: I've since realized...

unfortunately, i do not have access to the db till the beginning of jan...some rare time off...:D I will revisit this thread then though. I appreciate your efforts though. (I figured a lot of people would have need for something like this, and am actually quite surprised that I couldn't...

the function was basically: Function UpdateQueries (QTable as string) Dim varx,vary as variant Dim numqueries as integer numQueries = DCount("[Order]", QTable) For x = 1 To numQueries varx = DLookup("[Query]", QTable, "[Order] = '" & x & "'") vary = DLookup("[Run]", QTable, "[Order] = '" &...

no...order is actually a text field, i had problems getting it to work with a number field

thanks for the reply... QTable was a String parameter that I passed through the function, so it is equivalent to the quotes...also, I did try putting the tablename directly in the DLookup...it refused to go back to its working ways Ive read that this error is sometimes indicative of corrupted...

Hi, I often have need to run queries in sequence, (sometimes as many as 100 in a row). Obviously, I do not want to manually create a macro to do this. This is what I used to do: I'd use QueryDefs.Name to drop the query names into a table QTable... Order QueryName Run 1...

Also, I found this pretty cool function, to suffix the word "Continued" to any header that is being repeated at the top of a page for instance...here is the code (I would cite the source, but unfortunately I lost the link where I 'borrowed' it from) Private Sub GroupHeader0_Print(Cancel As...

Ignore me guys... After a lot of searching I figured out the way you 'snake' reports, as they call it, is through the Page Setup, Columns Tab... You can display reports in telephone-directory format If anyone's interested the Solutions.mdb Sample database, displays this in the Report...

Hi, this is such a simple report....or so it seems Two tables: Table1 Fields - Group, Group Description Table2 Fields - Group, Equipment, Status I have two problems really: 1) This report is potentially huge (35,000+ records). How do I spill over? For example, if Group is the Header, A is...

Hi Pat, The linked table's source is just another Access database...owned by me as well.

Hi AR, I changed the properties to Unique Records = Yes... ...same error message

We, over here in the stone-age, just switched over from Access 97 to Access 2002... I used to have a routine that: Ran a delete query and then an Append query to add updated records to a LINKED table. Reason I did this (and not a MakeTable) was to preserve indexes, keys etc A2002 wont let...

Thanks Autoeng, I used one of those links to build the tree (toughest challenge for me was not the tree syntax, but actually figuring out the iteration algorithm in my code, to convey the hierarchical nature of my data) it was a great help though...thanks again

thanks, anyone have an example of a tree control?

I have data (Bill of Materials) in a table, with this basic structure: Parent Child Level - A 1 A B 2 A C 2 A D 2 B E 3 B F 3 B G 3 C J 3 C K 3 E H 4 F I 4 K L 4 I want to be able to output this in a tree format, eg: A |_______ B |_______ | E | |_______ | |...

Forgive me, I've been away from Access for a few months, roadblocked.... Is there a way I can output the result of a query in a msgbox? Namely, I've got a table with customers. If the new form's customer matches one of the customers in the table. I want to output in my Msgbox ("Found:"...

solved it...ever notice how sometimes when typing it out, a problem and it's answer become clearer to see? maybe it's just me.... [This message has been edited by wrek (edited 08-28-2001).]

I've got 4 subreports attached to my main one - I only want to display them, if they have data, and I don't want blank space between them. I know there must be an easy way to do this. Any takers? (The HasData function, I suspect?)

Thanks Jack: Worked like a charm. (which really is an inept phrase if you come to think of it - when's the last time you've seen a charm work?)

Hi, I was wondering what the best way to let a user know that there will be a potential delay (Something along the lines of, "Please be patient and Don't boot up your computer, as this form takes a pretty damn long time to open") I tried the docmd.hourglass, but that only changed the icon...