Search results

Better to have each user with their own copy. Also, my program tells users to close down their database when it is opened.

"because it has to be printed a certain way excel needs to be used" ?? Sounds like a lot of extra work, you sure access can't do it?

Yea, here is a sample of it. http://rogersaccesslibrary.com/download3.asp?SampleName=Animation.mdb

Wow, thats looks like a lot of effort. Uhm, I didn't have time to read all the posts, I read the first two, and if you are just trying to have the persons name and time, cant you just set the default value for username to Eviron("UserName") and the time to the current time?

I think we need to get a "problem solved" thing for posts, so people don't click on posts that are already solved.

Have to use an append query, or cut and paste the data into the table. Append method: Link each table into your current DB, then use the append query to append one at a time. IE: tblData = Main table. (the final one) tblCompA \ tblCompB - Linked tables tblCompC / rename tblcompA to...

Why are you using text boxes? Shouldn't you be using Combo boxes? Not really sure what this is for..

Use an SQL backend and make a web database using ASP or PHP. Also, what does "WOT" mean? lol

Hmm, check this out... This is the code for a little VB program I made that updates databases when the user clicks a button. ( I may have borrowed some of the code from somewhere. It was a long time ago so I can't remember) Here is the button to update a database Private Sub cmdCopier_Click()...

Compact and repair both databases.

hehe pat, he did ask how. "just wondering how I can achieve this??"

^ http://www.zada.com.au/accessaddins.htm I use MZ Tools http://www.mztools.com/

As far as I know, you can't have an MDB backend on a web server. I would use an SQL server. (MySQL, MSSQL, etc..)

Why load 2003 on a diff machine? Run both on the same machine. I do.

"Windows XP is far superior to Win98" Not in every situation. IE: 98 on a p1 is faster than XP on a p1 (if thats even possible). however, on a p4 3ghz with 1024mb ram, xp is faster than 98.

Turn off read only.

How would I get the second tab to work in this? Just curious what the best way would be? That is, getting the date selectors to work. There is no data in this database yet.

I have both on my computer. I hate access 2003. Why: For one, the Linked Table manager was buggy. I use tables linked from MySQL ODBC Connector. The linked table manager in 2k3 sometimes wouldn't show any tables, and sometimes it would show them all ok. I used it for about a week when it...

Not sure what you mean. At 60 minuits do you want the database to take the 4 most current updates, and average them on a form? or do you want it to put it into another table? or what? Is the data already in the database? or do you want it to happen every hour while the database is open? You...

Function DateDiffW(dtmDateRequested, dtmRequestCompletion) Const SUNDAY = 1 Const SATURDAY = 7 Dim NumWeeks As Integer If dtmDateRequested is null or dtmRequestCompletion is null then datediffw = 0 else If dtmDateRequested > dtmRequestCompletion Then DateDiffW = 0 Else Select Case...