Search results

I have and Access MDE attached to a SQL database with multiple users some of which are roaming profiles. The mde is in a local folder on each machine. On 2 of the roaming users when they open the file for the first time on their office machine it works correctly. However once they log off and...

Access Front SQL back program. When I export a report from my program into Excell the fields with checkmarks disappear. Help!!!

I Have a list box that displays several fields for each recordthe user is able to double click on the row and open the Data-entry form for the specilied record. Of the fields in the list box 3 are Datetime (SQL) The data displays as The Date and time together. I only want to see the time for...

I have two date time fields (time in and time seen) from whick I am calculating the wait time needs to be hours and minutes. This works correctly however I cannot store the data in SQL for the wait time. I know it is due to the dtatype as I am getting an overflow error. However I am not sure...

I have a database that is an Access 2003 front and a SQL back. I have established security using active directory account. My editors/data entry group works correcty. However my second group is unable to see the data. This second group needs to be able to view all the data and only edit one...

When I try to restore my master from a back up fiel it says I need to be in single user mode. How do I get there? SQL 2000

I am chnaging my database from an Access/Access environment to Access/SQL. I have moved my tables and linked all of my tables to my Access front. Now I am having two problems. First, If I go to an existing record I can see it but not edit it. Second, When I go to open a new record I get the...

I am trying to Import data from an Access 03 database to my SQL 2000 server. Whe I user DTS it allows me to enter my type (Microsoft Access) and give my location and a user name and password. Then it gives me the following error. Error Source: Microsoft Jet Database Engine Error Description...

On form A I have a text box that I can type anything into and it is saved to a table. I click a button to open form B and the data from some of the fields on form A/the table are used to populate text voxes on form B. Everthing works fine until I type a time into the text box on form A that is...

I want to add code to a command buttton that when clicked prompts the user for two values (beginning date and ending date). The two value are then used as the begining date and ending date in a query (between...and) and then the query is saved with the two new values. The purpose of this is so...

My program is an Access 2003 database that connects to SQL 2000. I have a continuous form that shows between 10 an 25 records. I have coded an update button that when clicked updates a check box on each record displayed and then updates the form. Normally this works perfectly. However, sometimes...

I have a query that I export to a text file with fixed width settings. For one particular field that had only been one character and 5 spaces I used PGM: " " & [ProgramCode] for my field. The recipient of the export file requires that this field be 6 spaces long and leading spaces fill in...

I need to query a field for any records where this field has less that 10 characters. Any suggestions? The reason is depending on the type of customer the field can be 10 or 11 digits. IF there are less than 10 but not blank they need to be pulled for correction.

I have a custom switchboard that opens a data entry form based on several prompts (additional forms for user name date and password). Everything works correctly. When you close out of the data entry form, you return to the switchboard. If you click the button to open the data entry form again...

I have two tables, one for categories and one for records. I have sorted out the active records. But I only want to see each category once. Right now I see the category for each active records. What I am looking for is a list of categories that have active records in them.

Question 1 My Main From (continuous) Opens from a password form. If there are no records attached to the Employee it opens correctly. If there are records for the Employee then an Error Message opens stating “Reserved Error”. Any suggestions? Question 2 (same form) My Main From (continuous)...

In access 2000 I used the statement Dim conn as ADODB.Connection. In Access 2003 I get a ACompile Error: "User-defined type not defined." How do I correct the problem?

I have a query of records that are not related to records is the secondary table. I want to delete these records but when I select the records and click delete I get the confirmation to delete answer to delete them and all the records disappear. When I run the query again, all the records are...

I would like to record the username of the creator as well as the time the record was created (seperate fields). I have a trigger to record the last editor but that runs for each change. Is there a way to create a trigger to only run when the record is created?

How do I set the field so that you can only enter one of 3 specific letters?