Search results for query: *

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 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...

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...

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...