Search results

My bad it displays 0

When I run that, my message box displays "CurrentProject.ImportExportSpecifications.Count"

Sorry I'm not real good at this stuff. I've tried the message box thing but I can't figure out the correct code. I have done msgbox with If Then but I'm not sure how to do it for what you are requesting.

Thanks vbaInet, When I run the first code I get a "Compile error: Invalid use of property" and the .Count is highlighted. I marked out the rest of my code and I put that coding in my event procedure, is that where it should go? 'CurrentProject.ImportExportSpecifications(0).ClaimsExportSpecs...

I am trying to use the DoCmd.TransferText acExportFixed command to create a text file. but everytime I run the code I get the error Run-time error '2511': The action or method requires a Specification Name argument. I have created the Spec file by doing the export clicking on the advanced tab...

Plog "Queries typically don't use reports--its vice versa" my bad I had it reversed. Thanks for the date(), I guess I was trying to make this a lot harder than it needed to be.

Hello All, I am using Access 2010 and I'm trying to automate a report that we run every morning. What I want to do is click a button and have it open my query (query1) in design mode then go the Date field and change the Criteria to todays date. Is this possible? The other part of this is to...

in my database I have a query running and I'm exporting the fields of this query to a csv file. The export is working good but what I want to do is in my query I have a comments box that when I export I just want to export the first 70 characters of that file. This file is eventually being...

I figured it out. Didn't know you could use the between command in this situation. my code is Between [Forms]![frmExport]![txtSdate] And [Forms]![frmExport]![txtEdate] Thanks

The bound combo box is to a table that stores the workers names (tblCWorkers) Rick

My ultimate goal on this project is to take information from my database and export the information into a csv text file. Right now I'm working on phase 1 of my goal. I'm trying to run a query based on 3 fields of my form. On my form I have a Start Date text box (txtSDate) an End Date Text Box...

Thanks dK that will give me a direction.

I'm not really giving the users access to the table I just want the user to be able to choose 2 tables to compare. The number of tables will continually increase (probably monthly) and in order to cut down on possible user input errors if they can see May10, June09, July09.... that is a lot...

In my database I'm comparing data in 2 tables and returning the difference. For example Table1 will have Joe Blow $75 Table2 will have Joe Blow $50 then my query will return Joe Blow $75 $50 ($25). So in year 1 Joe spent $75 with us. In year 2 he spent $50 with us. so the...

CraigDolphin - Thanks Guy it's awesome. Exactly what I needed

How would I go about doing this: If ContainerType = Box then Container must equal a number between 1 and 200. If not in the range then message box. My thoughts are to put it in the Before Update section sound right? Along that lines how about this one: If a container number is already used then...

If I remove the recordSource form the form I get the error Object variable or With block variable not set

Same message. I've attached the DB. it's the frmEvents that I'm working on I thought that would be easier then me trying to explain it especially since as you can see I'm not real strong in access. I appreciate your help. Rick

I get You can't assign a value to this object when I set Me.LotID = Null

so on my LotID on the main form on open LotID=null?