Search results for query: *

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

Thanks to Reemul and CamaroLT the problem I have been having is now fixed. I changed the IRPStackThingy to 50 on the XP machine as well and it worked. Big thumbs [2thumbsup] up to you guys. This problem [bomb] is 2 years old. I will not miss it either. paveway [machinegun] Looking for help...

The SCL is a bunch of numbers a letters that stand for the stuff in the other columns. For example 2ABM2I in the SCL would be: SCL 20mm Chaff Flare Cap-9 120 2ABM2I 1 1 1 1 2 2ABCM2I 1 2 1 1 2 There...

Ok I have look through the FAQ's and searched the Forums for this answer. These are the fields I need for the drop down list. SCL Text 20mm Number Chaff Number Flare Number 9's Number 120's Number Now in a differant table I will have the same fields. I would like to be able to select the...

I have 2 ME, 2 XP home and 2 XP Pro and the ME computers run SETI@HOME only and I have to restart them every few days (5) or it triples time time to process the data. But with XP Pro I had one running the samething now for 45 days non-stop/restart with no problems. To me ME was a get rich quick...

I have the same problem but with a twist. I have 6 computers, 2 XP Pro, 2 XP Home, 2 ME. One Xp Home (XPH 1)is the gateway to the internet and all XP computers can get to the internet. No problems with files sharing between XP computer either. Now my problem lies with the ME computers. They can...