Search results for query: *

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

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

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

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

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

Today is my first day using Citrix (presentation server 3.0 on windows 2000). I'm confused about install mode. I have to install the windows updates. Does presentation server 3.0 use install mode like the older versions of Citrix? If so, do I have to use install mode to install updates, or is...

DLookUp("[user_defined_field]","sqluser_user_def_fields_MS"," [account_number] = form![member_acct_no] & [sequence_no] = 10") I'm trying to do a lookup of a user_defined_field in a table that has the same account number as entered on my form and a sequence number of 10. Can someone help me...

I have linked to a database that has a table that has these fields: acct_no, seq_no, user_defined If the seq_no (sequence number) is 1, then the user_defined field holds a birth date. If the seq_no is 2, then the user_defined field holds a mother's maiden name. So when I query the account...

If I upsize my Access 2002 database to SQL, will I have to create an ODBC connection to the SQL database on every computer that uses the database in order for people to access it? I have about 100 people who use it and have already had some corruption in Access. Sorry if this is a stupid question.

We run Exchange 5.5 and Outlook 2000. Is there a setting on the Exchange server to make all internal mail be plain text formatted, not HTML? Or do I have to visit each Outlook client to make the change? Thanks.

I created a form in Access2000 for a help desk request. When the user hits the submit button an e-mail is fired off to the help desk folks (the code is in the OnEnter event). The e-mail subject line contains the Ticket Number. The ticket number is an autonumbered field. (Thanks to all the folks...

Is there any way to get the logon hours in user manager to recognize half hour increments? Many thanks.

I have a table that has a field LASTNAME,FIRSTNAME. I want to be able to extract first initial last name from this (ie: JONES,BOB = bjones). Can someone help this newbie? Many thanks!

I'm confused about tracking external e-mail and hope you guys can help. We run exchange 5.5 on a W2K system. Everyone has an internal mail account. About half the employees have external mail that they pop from our ISP into their Outlook app. With our current configuration, is there a way...

I have a database that logs customer visits. I want to pull only records for customers who visited on Saturdays for the last month. Could someone please help me with the query criteria to make this happen? Many thanks.