Search results

Hot Dog... I GOT IT!!! For the string I did this If Me(checkcontrol).VALUE = True Then If itemcount = 1 Then str = str & "'" & Me(textcontrol).Caption & "'" Else str = str & "," & "'" & Me(textcontrol).Caption & "'" End If and then for the...

cool..thank you. After all the querydefs I written over the last two months..you would have thought I would know that by now. I tried that and even though no records where returned, at least I didn't get an error. When I went to look at why no records where returned the query showed the...

ok.. I am getting closer. I changed it to Set qdf = db.CreateQueryDef("qrystcompare","Select Vamt from Stbl where Stcode in '" & (str) & "') I just need to add the () around the name. But in debug mode i noticed that the last state had a , after it. so I may be having a problem creating the...

Ok... I am lost. I know how to create a querydef, but I have never passed a string of variables to select multiple records before. I tried creating an array, but even though the array populated, the querydef would not recognize it. I tried creating a string, but it recognizes it as a field and...

I have a report which has several subreports that make it up. When I am in the report view I can see all the subreports, but when I go to print preview, export the file to adobe or actually print the report, one of the subreports completely disappears. Because its in between two other...

Never mind. I know the answer, my problem was a typo. Think its time for me to take a break.

I am building a button to export reports to an excel spreadsheet. I know how to use the OutputTo with variables to save a file to a specific place. Example: DoCmd.OutputTo acOutputReport, stDocName, acFormatXLS, stDocPath, False But they want the ability to specify the directory location...

Got it, thank you. And nah baldy.. it's me. I don't think I have ever put 5 subreports into 1 report before and I am trying to find an easier way of doing it. So I am messing around trying to come up with different ideas.

Thank you.

This is the select statement from a (what I thought was simple) query. I have a table tblLogistics that I want to see all records from. I know that some of the lines will be blank from the other table because they don't all have the data I am looking for. I thought if I joined with a left join...

For anyone that is interested in solutions... I give kuddos to the Microsoft Technician. There is a bug in 2010. It appears that if you change the formatting of a report in Office 2010 Access while in the layout view that it causes the issue that I have been having. Microsoft is working to...

I need to have multiple subtotals for a group. I know I can add group subtotals, but that will break up the materials into different sections. What I am looking for is both the subtotals together leaving the material together. A short example of what I mean is this. Type Material Cost...

I understood that if you had a report which you wanted to insert into another report, that you could create a subreport and select none as the matching fields because I wanted the report "as is". But what is happening is, it is adding the sub report to the main report multiple times instead of...

You should also try to handle what will happen if its >5. Not that it ever will be, but its always better to expect the unexpected than not.

No offense husky... but I was just letting everyone know that the version makes no difference. It still had issues- same version, just a different name.

Just wanted to give you all my newest lesson with this... it has nothing to do with the version. I had made some updates the other day and realized I had not made a backup copy prior to making the changes.... Not a big deal, I thought. I did a File, Save Database As, changed the name so I...

In Update to use: Format([DateFieldName],"mm/dd/yyyy")

sorry.. that was just a typo, its like missing a semi colon after you've looked at something for too long. I will be more careful in the future.

In reading through some of the older posts on the different uses of DSum I am wondering if it is something like this that I should be using. My problem is though, its not letting me use the Dsum with an if statement. This is an example of what I have Code Desc Period Year amt 123...

lol.. not my choice to make.