Search results for query: *

That was very simple. Thank you very much. Works great.

I found thread 702-796789 that was exactly my problem, but I could not get the solution to work. Here is my problem in detail I have a form that has (for now) two combo boxes, one that I have been able to list my current tables less msys tables. Now I want to list the fields for the table...

I'll give it a read and try. Thanks

I have a Continous form that shows several fields from a query. What I want to do is: 1. When the user leaves the field, check that the field is not emtpy (I cannot set the allowzerolength to no as I have some records that have no info in the table, these are filtered out). If it is, I want...

I have a piece of code I am using to create a table: dim db as database dim tdf as TableDef dim strnewtable as string db = currentdb() Set db = OpenDatabase("h:\customer\master.mdb") Set tdf = db.CreateTableDef(strNewTable) With tdf .Fields.Append...

Works Great, couldn't be happier, you sir, are the Guru. Thank you very much for your assistance.

almost there, I watch the files be deleted, but no new files in their place? I get no errors, it is just not writing the new files to the directory.

The code works, only it renames all the files in the directory and I cannot determine if it is in any certain order. My thought was I would get the basic code and then alter it to be exact for my application, but this seems to be more than I can swallow. Here it is: 22 files generated by...

Thanks for the code, I input it and began to run it when I got my first error at: lngUScore2 = InStr(lngUScore1, varFile1(lngIdx), "_") the error was invalid procedure call or argument. I was understanding the code up to the loop portion. Do you think you could give me some idea of...

I receive 22 files everyweek. They are automatically generated by a mainframe and output in a text file format, the file names are something to the effect of: 0123shares_1_003.0903. All the numbers before the word "share" change weekly and all the numbers after the 1_ change weekly...

I currently have a procedure in place that will delete a table if it exists and use the docmd.transferdatabase to import all new data on a weekly basis. This all seems to work fine, the only thing I would like to do is, after importing the table, set the attibute to hidden using VBA. I cannot...

Subs worked great, just one small problem, I use the sub_current form to update the other boxes based on the control box, and it seems to go to the first record of the control query no matter what the load is as the sub_current use some simple = statements ei: newmonth = Monthname (field from...

I know this is possible, but I just can't get there. I have a form with a listbox as the control for several other fields, the list box is the "Month" ie JAN, FEB etc. I want to save the last month as the default setting for the next session. I have read about creating an INI or a...

I have a Table with a text field that has been properized, but I need to Properize (lowercase) or run a second function that will make these certain words all lowercase. I have created a table that list "oldtext" and "newtext" (example "Or" and "OR") all...