Search results

Just checking in. Did you get your concerns worked out? Still available to help. PB

Well, I don't see anything wrong with the code at first glance. Could you post the table structure and explain what you want to export and I can try to build a demo on my machine and see how it goes. I do work M-F days and have no PC at home so if this is urgent, maybe repost for someone who...

Is this code exact? Docmd.OutputTo acOutputQuery, "NameOfQuery", acFormatXLS, "C:\Path To Document", True If this is the EXACT code you're using, that is the problem. "NameOfQuery" means the name of the query like "GetData" or "Qry_Fields". whatever query you're using. "C:\Path to...

Hi all, What reference do I need to check to use the left and right string functions. I get Compile Error: Can't find project or library. for now. I'm using Access 2000. Thanks all. PB

Where is the import/export wizard????????????? Thanks but ......... Where is the import/export wizard? That is my question. PB

Hi all, I'm trying to create a new TransferText specification for a fixed width export but the help files are not helpful. I know the fixed width format I need and how to use the wizard, I just need to know how to navigate the menus to get to the place where I build it. Thanks everyone. PB

OH! The little details got me on that one. There was no code in it. Didn't know there needed to be. Thanks PB

Option explicit Look at the very top of the code text. If 'Option Explicit' is written there, then you are required to declare all variables. Dim mySQL As String mySQL = "Delete * from tableName" DoCmd.RunSQL mySQL PB

Sorry so late, been in meetings OK, Create a form by going to the forms tab. Click new. Select the wizard to help you through creating the form. If the form opens, close it. Right click on the form in the form list and choose 'Design' To put on a button: Select 'View' from the main menu...

More? If you need more info just post a new reply and I'll go over things like new buttons and forms and such. PB

Hey mySQL = "Delete * from tableName" DoCmd.RunSQL mySQL

Hi all, I have a form that I imported from another database. I can open it fine from the forms tab and everything works great, but when I go into the build event for the button I want to use to launch the form, it says 'object required' and the form is not in the project object list. How do I...

Hi all, I've got a form that I would like to change the background style on but the only properties I can find concern the color. How can I change the background to Sumi without going through building a new form? Thanks Patrick

My management is pressuring me to make some pretty ridiculous functionality that requires new text boxes to be added at will (business people, not computer people). The entire reasoning is to much to get in to here but it is not just a single text box. I need a variable number at any given...

Hi all. I'd like to add a new text box to a form from an event trigger (onExit of another text box). Any suggestions on how to do this? Thanks everyone. PB

Hi all, I have a field on a form tied to a date/time field in the database and the form needs a time (hr:mm). I am trying to speed up data entry by having the operator not have to type a colon in the time field. Is there a way for the operator to just type in a military time without the colon...

Hi all. I have a form that I would like to start up all blank (except the default values) and when the data entry tech moves to the next record for data entry (via a 'next' button or whatever), I'd like the data in selected text boxes to autopopulate the next entry set(since most data is entered...

Great Thank you all. PB

Thanks Left, then right then union..... I'm thinking that I'll be seeing 2 copies of the matches. I'll try querying the union for "Distinct" THanks all PB

I have a couple of tables that I want to combine and do matches but keep the non matches from Both tables. Is there such a thing as an outer join? or is it a matter of tricky manipulation? Table 1 Vehicle...........Motion F001..............123 F003..............234 F004..............345 Table...