Search results

Thanks a bunch!

I have about 50 variables to insert into a table. My code looks like: docmd.runsql "INSERT INTO ..." Problem - I need to continue the line at a variable. What do I do?

How do I trim the first two letters off of a string in a query? ex. Iif(isnumeric(fdrid),fdrid,I need the trimed word here)

I have a text file that I am tring to import. I have used the spec, fixed width, delimited width, and everything I can find. The Information that imports to the table is out of range. ie, two fields are populated, three are blank, one is populated.... etc. What do I do?

... thanks a plenty! Works like a new washer.

I want to display a label or text box on the report header. This label or text box will have a different caption pending on which button the users clicks on a form. What can I do to make this happen? ex. if cmdBucket is clicked ... then report label reads "Bucket 2" if cmdTotal is clicked ...

I want to import a query using an autoexec macro from another datasbase. When I try to use the results of the query, I get an error saying cannot find "ID Table Tulsa". Is this cause the query needs to be ran first? I need to retrieve the results and use in a form. HELP!

Works like a charm...Thanks!

I have a query with the fields: First_Name and Last_Name. I want to create a field that is made up of both fields and call it Name. Thus, Name = First_Name + Last_Name

That worked...thanks a lot!

I access application1 from application2 using this code. Dim Settlement As Object Set Settlement = GetObject("C:\Settlement3.mdb") Settlement.DoCmd.RunCommand acCmdAppMinimize DoCmd.Quit Application2 closes and application1 is now open. Problem...when I want to close application1, it...

supposedly, the query will return faster than the results derived from tables with relationships.

select the form, go to properties and click on data. in the recordsource, select the table or quey you want to bind to. hope this helps!

I have a Form that opens on start up. The form imports from a text file and transfers info. I have a command button on the form when it is pressed... the form load procedure fires again and imports the info again. I do not want this to happen. Hwo can I prevent the form load from running when I...

Once I get my site up and running I will without a doubt link up. This forum is great!

Yes, But I want to know how to prevent it instead of just turning my head and looking the other way.

I am attempting to kill a file. I first need to know if this file exists. If it doesn't, I get an error that says file not found. What can I do to see if the file exists before I try to kill it?

use after update

Create a command button. In the code, type: docmd.runsql "SELECT * FROM table WHERE Item#2 = "<- a field in that table. Include all the other criteria you want. Bind this query. If the query returns a value, have the pop-up box display.