Recent content by pavewayammo

I'll give it a shot when I return to work monday. I'll keep you posted. paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the FAQ's first then do a search then ask. Worked for me.

This is easy to do. Open up the database then go to Tools>Database Utilites>Convert Database> then select the which version you want. paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the FAQ's first then do a search then ask. Worked for me.

The output from the first Access DB is not changable. It is a MDE file and the DB owner has locked it so we can't make changes. Also they don't want a add/change any of it's current features. I am so close to just linking to the first DB anyway and deal with the heat about it later. paveway...

Ok here is my problem. I export a table from an Access database into an Excel spreadsheet then in to another Access database. I know it sounds stupid but I can't just link the two Access databases or make any changes to the orginal Access table exporting from. On export, the time is in 24hr...

I think I should have posted this on the Access Table and Relationship forum. paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the FAQ's first then do a search then ask. Worked for me.

Ok here is my problem. I export a table from an Access database into an Excel spreadsheet then in to another Access database. I know it sounds stupid but I can't just link the two Access databases or make any changes to the orginal Access table exporting from. On export, the time is in 24hr...

Also note the star. paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the FAQ's first then do a search then ask. Worked for me.

I'll have to do that when I get home because they have the computer security set so high here and not everything is installed for Access. Oh and thank you very much. It works. Now I just got to figure out how to make time stop so I can finish this before the dead line. paveway [machinegun]...

Ok I'll do that but what does Nz do? paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the FAQ's first then do a search then ask. Worked for me.

Ok I have been messing with Access databases for 3 years and lately been digging in to the SQL part. I have no idea what Nz is. Can you point me to right place to understand it so I can get this working? paveway [machinegun] http://www.deagel.com/img/lib/1v9961.jpg Looking for help check the...

Well the error doesn't come up any more. Now the when qryCountTLO.T is empty it makes Available empty also. I also looked over the SQL a little closer for the second part and found it was messed up also shorten a qry name too. This is what you had me add/change. Here it is corrected: INSERT...

Ok here is my problem. I have a table with personnel status. The status field can be either blank or have an l,t or o in it. I figured out how to get the totals for each but my problem is when no one has one of them. For example if at least 1 person has blank and l and o but none for t. I get an...

Ok I have looked through all the FAQ's and searched the forum for this but just can't find the help I need. Here is what I am trying to do. I have 3 fields (DateSubmitted, LeaveStr and LeaveEnd). I need the DateSubmitted to be updated with the current date when either of the other two fields...

I have an import question. I have been looking for a way to do this for a couple months now. I have serveral .html files that I would like to import. Now the catch is there is 4 tables in it and other text. When I go to file>Get External Data>Import.. it only imports the tables. I would like to...