Search results for query: *

How do I extract a list of table field names and put them into a different table?

I have a query which has a cross tab query as its source. So the "fields" change often. I want my query to just pull the field names and put them into a table. Over my head.

I have two tables and one form. One table is the row source and the other is the data table. A common field UniqueLastName ties the two together. I have several combo boxes on the form. When the user picks a last name the whole form should populate with the persons other info and save it to the...

I get the error message "Control can’t be edited: it's bound to unknown field MyName" when I click on a choice in a combo box. Am at end of the rope on this. All the other controls work and are much like this. Just hoping someone can give me some ideas on this - Thanks - Larry

I have a combo box on a form. When the form opens, Set Focus is on the box. I want to require the user to select a name from the drop down or not be able to go to other boxes if they do not. Ideaa please. Not seeing what I need from older tips so far. Thanks

In my detail section, I need every other line to print in bold. Kind of green bar effect to make the report to be easier to read. I know that some code needs to be in the format section of the report that loops as it prints. Thanks - Larry

I have a function that works fine to kill files over 2 days old but wish I could kill files that have file names ending with, for example, a sequence number. For example I want the function to kill files like this C:\My Documents\Johnson datafile-544.doc but not to kill C:\My...

Just need a idea to kill a file if over so many days old. Something like this: Function KillOldFile() If C:\My Documents\MyFile.xls is over 3 days old then Kill End Function. I know its simple but still over my head as a user. Thanks

Need a function for Excel XP that will run a Outlook XP macro that I specify. Thanks - Larry

Hi: A need a function for Access 97 so when run will run a macro I created in Outlook XP - Thanks - Larry

I am trying to export text using the Access Export data (Transfer Text or the command TransferText) but my final output is not what I want. I want no time stuff in the day/date section and no decimal point or anything to the right of the decimal point. My output table is set just fine. It just...

How can I delete tables using code? Need to delete tables that result from less than perfect imports. The table names all start the same name of coase but end with 1,2,3 etc. Or to be exact: Brecksville$_ImportErrors1, Brecksville$_ImportErrors2, Brecksville$_ImportErrors3 etc etc Thanks for...

I am trying to run another Access 97 database from within my currently open database. The goal is to use some buttons on my main database to run others that move data around. This code kind of works but never finishes and something sure is not right. Comments please - Larry Function...

Over my head. I need an Access function to rename a file and append the current date to it. Ideally from Access I can click a button and it’s all over. I would probably have around 6 buttons that I can click daily to process the 6 files when needed. Wonder if I could even maybe add hour. Thanks...

I need to have a function that will print a DOC file when I click on a button on a Access 97 form. I suppose Word has to open a bit, print and then close. The file has a specific name in a specific folder. Over my head at this point to do the code. Thanks much!

While preparing reports, I need to change my monitor’s screen resolution often from 800 to 1054 and back. Any way to write code to do that?. Would be so very nice to just click on a button on a form to do that? Thanks

I have created many reports (Access 97) that output to Word and all is fine. But when I move the database to a different computer. The reports come out with some right side cut off, dashes are shortened, some text put into next line etc. Why? Using same HP printer. Same software. What setting or...

I have seen other post to do with synchronizing records between 2 forms but they are different enough and over my head so here goes. I had to split a big tabbed form into 2 tabbed forms because it had too many controls. So all I need to have is the same record appears when I open 1 form or the...

Is there code that can run when a form opens to force the scroll bars to the top? This is sort of a afterthought to a earlier post about my tabbed form not opening showing the tabs. I suppose the tabbed form is too long but I can't do anything about that. Just want the tabs to show on form...

I have been cleaning up a tabbed form that has been a problem because it will not allow any more contorls. So I created a new form and moved some of the controls to those tabs on the new tabbed form. But now, when the new form opens it shows the lower portion of the form requiring scrolling up...