Search results

Can you post a sample database of what you have so far, I know your trying your best to explain, but it will be easier to see a sample. you mention Excel and Access but I don't follow exactly what your goal is. Your Tables store the data and queries are used to manipulate the output based on...

A query can be joined to a table the same way 2 tables are joined, and 2 queries can be joined...actually more than 2. without having your data to work with it's harder to visualize...but one thing to watch out for is when you add the table/queries if a default join appears due to...

first make your Sum query and then make another query and join the sum table to the query. for the date criteria try... Is not null ...by itself don't put the date1 field in the criteria

I have 2002 and I can define it in both?

thanks for the tips, I DO like what you said about the SQL...I see it is appending to the variable with each line, i will definately use that...I'm not a big fan of writing SQL, I'll load up my tables in the query grid and then copy the SQL. I understand what you mean about the naming...

yes it I was having fun manipulating the files from Access...never had a need to until now..good learning experience. Anyways, here is the code I put together...I had found some code by rsmonkey which got me pointed in the right direction. I added several pieces to it..notably renaming the...

thanks, I figured out a solution using CurrentDb.Execute StrSQL I made up a string for an append query and included the variables I wanted to Pass. I'll post and example when I clean it up...I'm doing modifications as I think the whole process through. so far I am importing, appending and...

Hello, I'm working on code that checks a directory and imports files matching a certain criteria...I have this working What I want to do now is take the filename and add it to a field so the records will be related to the import file...do I need an append query and then pass the variables to...

No problem, I looked at my attachment again and the "Block" I was referring to was not set (must have undone it by accident)...anyways for anyone else trying it just double click on the line you want the code to stop at and it will add a "Dot" for debugging.

Sean, I got off topic in my suggestion, although it does work to open a specific report, you were on the right track with this... ( don't need a table as I had in my suggestion)... Private Sub Command0_Click() Dim stdocPath As String stdocPath = "C:\Documents and Settings\Work\My...

here take a look...I added a variable for the path also

sorry, I thought I uploaded the sample DB that I setup...it's on my other PC so I'll either upload it later tonight or make up a new one later... but set it up like this.... first make a table to store your document names 2nd make a form add a combo (Assume it is called combo1) that looks up...

this might be a better way... Private Sub Command0_Click() Dim stdocPath As String stdocPath = "C:\" & Me.Combo1.Value Application.FollowHyperlink stdocPath End Sub I hardcoded the path, but you could easily include it in a table just like I did with the Filename. you will have to edit the...

This works, =IF(AND(ISBLANK(B1),ISBLANK(B2)),"TRUE",IF(OR(ISBLANK(B1),ISBLANK(B2)),"FALSE","TRUE"))

can you post the function or even a stripped down sample of the DB with only the report and sample data? although you want to automate the name, I was going to suggest this in the Open event of the report to let you name the report when it opens. You could also pass it from a form Private...

Are you changing a label name or a bound control name? You can use the nz function to put a Zero in... Expr1:nz([Calculation],0)

The Macro Message box won't suffice, you need VBA. I attached a sample, where you can adapt the VBA to run your Macro's. You can also convert the macro to VBA and incorporate it into the code. *in DB window with Macro selected...Tools >> Macros >> Convert to VB

look at the tables you are appending to...change all the fields ( unless you want to figure out which one) to "Allow Zero Length" in the field properties. You should test this with one table...I can almost guarantee this is your problem...I've been down this road. I think another way is to set...

this is MS Access I assume, what version? and you don't have any sorting set in the query? I can't see it sorting your table if nothing is set in the query to sort?

do you know for sure it is a Mavro versus VBA (coding), in Access a Macro is a series of Actions you select, and then the VBA is actual coding to do the same..an Access macro is not the same as an Excel macro. You need to go into the design of the form then open the property of the button that...