Search results

Isskint, This is what I finally ended up with: Dim db As DAO.Database Set db = CurrentDb Set qdf = db.QueryDefs("QLightDuty") qdf.SQL = strSQL DoCmd.OpenReport "Report_LightDuty", acViewPreview,,,acDialog Seems to work; do you see anything that should be changed? Now, in order to...

Isskint, Part of the code came from my old vb6 for loading a datagrid; the other part came from a friend I made on this forum (DrallocD). Trust me when I say I am a beginner at Access. It will never cease to amaze me of the generosity that is given everyday on this forum. People who take...

I see what you mean, but I am not sure I know how to do this. Would I place my code to populate the subform into a module and try to call it in the source for the query? or a function and call it this way: DoCmd.OpenReport "LightDuty", acViewPreview, , "LightDuty = funcSource I...

Hello all, I am trying to generate a report from my subform, but I am not having much success in doing so. I am getting either all the records or nothing in my report. My subform is populated from an unbound listbox; here is the code that is used to populate the subform: 'Populates the...

John Big Booty, That did the trick! I knew that the function of IsNull was not the correct thing to use; I even used IsNull by itself. I think I tried every combo, but I never tried splitting the IsNull to Is Null, arrgh! Anyway, thanks for the help!! Can anyone recommend a really good...

Hello All, I am trying to create a query that checks for a couple of criteria. The first one works fine, but the second one I am having a bit of trouble with. Here is the code: SELECT LightDuty.FDID, LightDuty.[First Name], LightDuty.[Last Name], LightDuty.Unit, LightDuty.[Permanent...

Anyone having any issues with running Access 2010 on Windows 8? I just purchased a new laptop two days ago and installed Access and it ran just fine. Well now, no matter what control I click on, Access stops working and restarts! Arrrggh!! Oh, by the way, should I have started a new...

SWEEEEET! Works great Mr. pbaldy! Thanks again for the help!

Hello all, I have yet another beginner question and I have not been able to find the answer searching through the topics. I have a form (DateSearch) with 2 datepickers dtStartDate and dtEndDate along with a command button cmdSearchDates. I created the macro to search the dates from a query...

lagbolt, Thanks for the sample that you have posted. I have already tried that, but I wanted to just use the subform by itself. I forgot to mention (in my last post) that in my real project I have several tabs on my form with listboxes that populate the subform with several records...

lagbolt, If the project works for you, then there must be something wrong with my version of Access 2010. It will not work for me at all. I will try to reinstall the program and see what happens. As far as using just one table to populate the subform; I wanted to display the info in a...

Ok, I created another project and just included the main form with the listbox and subform on it.

Hi Bob, Yes, I did the compact and repair. I then removed 3/4 of the project and then zipped it with winzip, but it was still too large. I then removed more of it, then it started to malfunction big time.

lagbolt, I cannot get the database small enough (to meet the 2mb maximum) and still function. :(

Is there any hope for me, lol? Any ideas, anyone?

lagbolt, Here is a pic of my table where I am trying to extract the record from to populate my subform I am using the following and it works in the query designer. So why in the world will not populate my subform? Do I have my subform setup incorrectly? strSQL = "SELECT CWRVerb.Verbiage...

Ok, this is what I have changed and it is still NOT working, argggggh! strSQL = "SELECT CWRVerb.Verbiage FROM CWRVerb WHERE CWRVerb.CWR = """ & strCWRFieldSelected & """" I placed this code in the query designer and it comes back with the desired results, but the record is still not visible...

Where would I find sql designer in access 2010? FOUND IT, lol! lagbolt you are correct; this is what the sql designer is showing: Expr1000=CWR1(H) over and over (10 of them) Question is: how do I correct this?

lagbolt, Thanks for the response to my issue. I opened the immediate window and the sql seems to be pulling what I want. I only have one record for each field. Here is what the sql is pulling: SELECT 'CWR1(B)' FROM CWRVerbiage the CWR1(B) is the selection from the lstbox (lstCWR). I...

Ok, I got it Bob! I am learning something new everyday with Access. I was adding textboxes by just dragging them onto the form, but I just found where I can use the "Add Existing Fields" to create auto links. Thanks again!! (you got me pointed in the right direction)