Search results

OK, I've read through all of that, and now I'm more confused. :banghead: I'm in a situation like this right now, and my biggest concern is reducing the size of the questionnaire database (over 800MB right now). There are things I can clean up (like substituting Employee IDs for their actual...

It looks like you named your query the same as the report. More than likely, Access was confused by the two. I recommend always naming queries with the prefix qry, forms with the prefix frm, and reports with the prefix rpt. For tables, place the name in all caps so the names of tables stick out...

Are you able to post your db like I did in my example? There has to be a small error someplace that's stopping the report from reading the dates off of the form.

That is a bit odd. I just made a mock-up of a form with two text boxes and a button that previews a report, and it worked perfectly well. Perhaps there's something here that will help.

Run the query by itself with dates filled in on the form. If it still asks for parameters, the error is there. If the query runs correctly, then the values in the parameter are not getting passed through to the report.

It's hard to tell with what you've written because the code we'd need to see is tied to the button that opens the report. The code Namliam gave you in the other link should be tied to that and you just have to fill in the names with your query and text box names. Can you post the OnClick...

Is this the exact code you have in VBA? Because what I see in the pic is a form called FrmFiles and the Combo box selected is Combo198. I would think the code should be Most importantly, the bound column has to be the same column in which you're searching, which is currently the Group Code...

Good suggestion on the MakeTable idea. Access deletes out the old one every time, which should get me close enough until I have time to trash everything out and rebuild this thing. (The IT person here isn't thrilled with this database either and left me on my own.) Thanks! ADDITIONAL: This...

Sorry, yeah. The union query does indeed create 600,000 records. From what I can tell, they originally made a union query out of all the possible permutations for each check box (for each item to check, there are four checkboxes, thus four combinations, plus an N/A) So, for every record in...

I apologize for this one, but I inherited this for my new job last week. The company I work for has a database of safety cards recorded in an Access database. They use pivot tables in Excel with the data linked in from a union query in access. The reason why is because they were attempting...

I can certainly understand not wanting to use them. But my problem is this: I need to make a list from which a user can select multiple items and the values of those are placed in a single field in the table (separated by commas). The research I did online was pushing me towards using a Lookup...

Truer words were never spoken. Thankfully for me, I only get in trouble on days that end in the letter "y". Have fun, and please keep up with the group ahead. (wait, this isn't the golf course)

I found this link in one of the other combo box threads. It looks really detailed and easy to follow. http://www.fmsinc.com/MicrosoftAccess/Forms/combo-boxes/cascading.html Plus, I haven't contributed in a long time and I thought I should. :-D

Still hanging on to my 2005 Honda Element. I thought those things were so cool when they came out, but for some reason, I never took the moonroof off in the back and only once did I use the seats like a bed as they had advertised. But it certainly did its job. 116,000 miles and still going...

Make sure the name of the box on the form is not the same as the name of the field which it represents. If the name of the field is DippedStart or DippedEnd, you should name the box something like DippedStartBox or DippedEndBox. Typically a #NAME error means an incorrectly-typed formula or a...

Although it would make your formula longer for the title, you can add an IIF statment to check one of those boxes (DippedStart or DippedEnd) to see if they're null, and if so, write a different title. =iif (isnull([Forms]![NetCriteria]![Dippedstart]), "This is my Report", "Report for...

I see a couple of {'s in your code instead of ['s, so you may wish to correct that. The best option for your title is the code everybody's given you. ="Report for " & [Forms]![NetCriteria]![DippedDate]![DateFieldFrom] & " to " & [Forms]![NetCriteria]![DippedDate]![DateFieldTo] But if your...

To quote Emily Litella, never mind! In the VBA code behind the button that would call the pivot chart, it was formatted to open up the form as a single form rather than a pivot chart. So I needed this DoCmd.OpenForm stDocName, acFormPivotChart, , stLinkCriteria ...instead of this...

There isn't a magic "clear form" button. However, you can place a button on your form and use the following code as the OnClick event... Dim Response As Integer Response = MsgBox(prompt:="Are You Sure?", Buttons:=vbYesNo) If Response <> vbYes Then Exit Sub Me.firstbox = Null...

I'm sure this has been discussed before, but have any of you made a pivot chart, and then went back and made changes, only to have the form open up as a single form? I already checked the properties, and nothing was changed there. And ordinarily I wouldn't use Access to make a chart, but the...