Recent content by ChuckCasey

I'm running Access 2003. I created a macro that imports a text file into a table. The text file is just a list of account numbers, only one column of data. I want to add a date column to the table and populate it with the date the macro is run, but I don't know how. Can I do this using a...

I have 3 unrelated tables with the following fields: table1 table2 table3 WireNo RecordNo RecordNo SDate Sdate Sdate EmpNo EmpNo EmpNo XferAmt Amt OrAmt Fee Fee Fee I need to...

Some records disappeared from my table and I can't figure out what happened. Any ideas are greatly appreciated. I have a database that is split into front end and back end. I opened the front end, made a change to a form for tab reorder and pushed out a new .mde file. That's it. I got a...

Thanks, you folks are fast. Left worked. Many thanks.

I'm having a huge mental block and can't remember the word for it, but I want to shorten a field so that only the first 5 characters are returned in my query. For example, I have a a table that stores employee number and name in the same field (Don't ask why, I didn't create it, but now I need...

You are THE man!! Thank you. It works great! Have a star.

I created a database for submitting service requests. The request form is filled out by the requestor and submitted, then finance updates the record as needed. When the service is completed, finance closes the ticket by choosing "Completed" from a drop down box. At any time during the process...

Thanks so much!

I appreciate the quick response. Many thanks. I'm very much a newbie at this. Could I impose on you to tell me how to create a 2002 version of the MDE's? Thanks.

I have several databases (Access2002) that people connect through from .mde files. Over the weekend, the technology staff upgraded some of the computers, including the one where the databases are stored to Office 2003. I edited two databases and created new .mde files. Now, anyone running...

Thanks very much. It worked like a charm!

I want to create a button in DatabaseB that will open a report that is in DatabaseA. I created a reference in DatabaseB to DatabaseA. I built a module in DatabaseA with the following: -------------------------- Public Function OpenNSFReport2() DoCmd.OpenReport "rptticketsbydate", acViewPreview...

I've searched through the posts here on this topic and I'm still clueless. I have a form (frmSubmit) tied to a query (qrySubmit). Data is input for these fields: custID,BankName and xfer_amt (there are many more fields, but this is enough to start). Many times the same request is made more...

I recently resigned from a company (moved out of state) where I was the network administrator. While I was there, I created some access databases, just for fun, as learning tools. The company implemented a few of them and it was fairly successful. Now they want me to do some work for them...

Ok, you folks are really good at answering my newbie questions without making me feel stupid, so here goes. How can I tell if there are network connectivity issues between two servers? We had a nework with one domain controller (windows 2000), the network admin added another dc (windows 2003)...