Recent content by ejhatch

Hi All, I have a approximately 70 queries in my database. I would like to be able to run a query which would run all of the queries and output the number of records for each query. Ideally, these would then be written to a table so that the user could then just read the values from the table...

Hi Neil, Thanks for that. Evan

Hi All, I have a table called tblcheck which holds the following values: IT, Yes/No 0001, Yes 0002, No 0003, Yes I need to set up a query which outputs certain values depending on which of the IT values have been set to Yes. I need to take into account that a user might have all of the values...

I am trying to write an append query which is based on a table (PA0041)having muliple columns. The columns are DAR01, DAT01, DAR02, DAT02, etc etc. The data for DARnn will contain values such as S1, S2, S3 etc. For each of these values, there will be a corresponding date in the corresponding...

Hi All, Is there any standard Access functionality which can tell me which tables are used in each of my queries. Failing that has anyone ideas on some query I could develop or code that I could write which would give the required output. Thanks, Evan

Hi All, I have built queries based on tables. The field names are the technical field names of an application. For example pernr is actually Personnel Number etc. My queries are set up as follows: Field = pernr Table = etc I would like to rename pernr to Personnel Number so that the column...

Hi All, Thanks for that. I tried the different ways and the best way I managed was to use the left function and pull back specific text. Thanks, Evan

Hi All, I am trying to use a wildcard in a variable. I have set my variable as follows: dim stDocName as Variant In the code the stDocName gets assigned the name of the query. In certain instances this will be = qryFutureDatedIT0000 or qryFutureDatedIT0001 etc etc. I want to be able to...

Hi All, Thanks for the advice and comments. If I decided to use this method it would definitely be done in the foreground so that the user was completely aware of what was being mailed out. I understand the issue if a user does not have a default email client set up to be used. I might try...

Hi MStef, Thanks very much for that. It seems to work perfectly. Thanks, Evan

Hi All, Thanks for the comments. Yes, I would like to sell the product so that would preclude me from getting into the various copies of the databases. Perhaps I could write the error messages into a table or form which the user could email to me whenever they hit an error. Thanks, Evan

Hi Smart, Thanks for that. But I would still need to create a new table based on these system tables where the entries in my table would be supplied as a list from these system tables. I guess the million dollar question is how can I use the contents of these tables as the source of a list in...

Hi All, I am setting up an Access db which will be used by different customers. In the event that they find an error in my VB code, I would like this error to be trapped and the details emailed to me. Is this easily done or am I just nuts. I would rather not have to rely on the customer taking...

I need to create a query based on the following 3 tables. table PA0001 has the following entries (first line is the header data) EmployeeNumber - ContractType0001 1234 - 1 1235 - 2 1236 - 1 1237 - 1 1238 - 2 1239 - 3 1240 - 2 PA0016 has the following entries: EmployeeNumber -...

Hi All, I am wanting to build a table which consists of all the queries and tables in the database. I am expecting column 1 to have all the queries and column 2 to contain all the tables that make up the query. So the table will look like this: Queries - Linked Tables Query1 - Table1 Query2 -...