Search results

Hmmmm. Are you willing to redesign your tables? If so you can set up an Aircraft_Reg table, and include the Aircraft_Type in that table. Then in Aircraft Details you would have a fk to the Aircraft_Reg Pk. Then you could display the Reg and the Type on a form either using a dlookup in an...

Try putting your space before the start of the next line as opposed to the end of the line above. Like: "SELECT Sum(IIf([Type]= 'RESI', [Amt], 0)) AS Ind," & _ " Sum(IIf([Type]= 'RESM', [Amt], 0)) AS Med," & _ " Sum(IIf([Type]= 'RESE', [Amt], 0)) AS Exp," & _ " [Date]" & _ " FROM transaction"...

Where exactly are you putting this? Are you by any chance putting it in the properties screen? If so that is why. You need to remove it from there. Then click on the arrow that appears to the right of the "On Current" event. Then, from the drop down list, click Build Code (or something like...

I didn't think about that, though, in dealing with people in my own office, I have discovered that they need things spelled out for them sometimes, more clearly then what you suggest. :)

As vbaInet said, you can put an unbound text box on your form, format it how you want, and include the If/Then statement as the control source. I was suggesting doing it in code so you could make the box visible or not depending. If it's not paid and not past due then you wouldn't need it to be...

Try adding your name field again as a group by

Where do you want this to "flash", it can probably be done, but you'll have to use vba, and an If/Then kind of deal. depending on exactly what you want and when it will determine on which event you put your code.

Google "Cascading Combo Boxes" and see what you come up with. Ask back here if you don't understand what you are reading, you can even limit your search to this site if you use the advanced search options.

Thanks for your help! For completeness sake, I did build a query, and it works! :D Here it is: Function ErrorLog(ByVal ErrorNum As Long, ByVal ErrorDes As String, _ strCallingProc As String, ModName As String, Optional bShowUser As Boolean = False) _ As...

Thanks! - I do have that checked.... Also, I looked back and I didn't read far enough in the web page that I found where they told me the exact same thing that you just did.... :o Back to the drawing board... Could it have something to do with me trying to update an SQL table? I think maybe I...

I tried what you said and now I am getting Error 91, "object variable or with block variable not set" - earlier this led me to think about references, and how when I was setting mine I couldn't find the dao one, and I forgot to figure out why until now. I'll try any other suggestions, but I...

SOLUTION TO MY PROBLEM: After narrowing down and narrowing down where the problem originated from, I found that there is no DAO reference..... So I then googled that for Access 2010 and read that Access 2010 does not support DAO, hence my code will not work. What I read suggested to update all...

Hi All, I just moved my tables to an SQL server, and linked my tables to my Access 2010 front end. In this db, I have a table for error logs, and used code I found on Allen Browne's site to log errors. It worked fine when the tables were in Access, but I get an error now that the tables are in...

What I am getting at is that your SELECT portion doesn't perform those operations, it pulls in fields, so if you have a field called "Type" that is built by that calculation then that is what need to be in the SELECT, not the calculation itself. At least that is my understanding. Edit: I just...

I don't know that the SELECT portion of your statement should be set up like that. See this link for a tutorial, this should get you going in the right direction. You also my consider designing one in the access QBE, either what you are working on, or something simpler just to see, and going to...

Ok, I am glad you found a solution that worked for you! :D

I can't help but think that you have too many queries... I may be wrong. But you could probably build a query with the group by information that you need. and the count info as well. - Group by Client Type, Group by Billing Levels, Count on the lab test ID maybe? Also you could probably export...

Check out this link, you need to look for the .mdb version of your database to edit it.

What is the file extension of your db?

See the attached pic, it should be similar regardless of access version.