Search results for query: *

Does anyone know an easy way to auto-populate combo boxes as you type? For example if you want to select the name 'Smith' from a drop-down list - if you type Smi - it will take you to that value automatically. This is easily done in Access, but I'm not sure how to do it in VB.NET. Thanks in...

I would like to "hide" the last 5 characters of a field when it displays. I have done this in Access using the LEN function: User:Len(Primary_User - 5) - but that doesn't work in SQL. Does anyone have a simple solution for me. Thanks for your help.

I would like to make a copy of one of my existing forms within the same application. Is there an easy way to do this? I want both the code and the design of the form. Thanks for the help.

Is it possible to use a job to import a comma delimited file directly into a table? This job would need to run nightly. Thanks for any assistance.

I want a query that displays all results entered on that day. This date is entered into the database via a GetDate()default value. Now that I want to get those results back out...I am having trouble because of the time that is affixed with the date in the field. I just want to grab results...

How can I use a stored procedure to select a record that was just added to a table? I want the most recently added record... I'm sure that there is an easy way to do this, but I am new to this and can't seem to find a solution. Any help would be appreciated. Thanks very much! [smile]

I am using Stored Procedures and Triggers to move data from a "temp" table to the "real" table. Once the record is moved from the temp table to the real table, I want to be able to delete the original record in the temp table. I have had success with this when I use the "delete from temptable"...

I would like to open a recordest (from a table) and use those values in a variable string. I am using a select * statement from my table to open my recordset. How can I capture the values of that recordset into a variable? Any info would be much appreciated. Thanks

I would like to use a multi-selection listbox to select values and store them in a table. I was able to do this in Access, but am having problems doing this in Project. Does anyone have any suggestions?? Thanks.

I want to update a table in one database, based on an INNER JOIN with a table in another database. I can do this in Access, but SQL is having problems with my syntax. Can anyone point me in the right direction?? The error message I receive is.. Server: Msg 156, Level 15, State 1, Line 1...

I have an access 2000 database that uses linked tables via a SQL 2000 database as its source. I am having problems with this type of setup because we have people accessing the database on multiple networks - slow performance. I have been reading that ADP could help with my slow performance...

I was wondering how to upgrade an exisiting Access database that has linked tables to a SQL Server to an Access Project? Any assistance would be appreciated. Thanks.

I would like to hide the last 5 characters of a field in a report. I have been playing with the LEN, MID, RIGHT, LEFT funtions, but can't come up with the right combination. Does anyone have an example of how I would do this? Ex: 123456789 would print 1234 and leave off the 56789 Any...

I was wondering if someone could provide me with a simple trigger that just displays a message on the screen whenever a certain table is updated? The reason that I am asking this is because I am trying to do another trigger, but it doesn't seem to be working. I want to make sure that I can get a...

I need to create a trigger that fires whenever the MachineID column is updated in my HardwareDB. I want this trigger to update any related MachineIDs in another database (SoftwareDB). I have tried some syntax, but I haven't had any success yet. Here is exactly what I need: DB1 - HardwareDB...

I am having problems with updating recordsets in my VBA code. Everything worked great when the database was in MS Access, but I upsized it to SQL Sever 2000 and now I am getting error messages when I try to update records in a recordset. Here is an example: You must use the dbSeeChanges option...

I was wondering if it was possible to use referential integrity to relate tables between databases? I have two database that use a similar table. If the value is updated in the primary table (first database) I want those records to update in the secondary table (second database). Is this...

I would like my Access database to automatically open the links to my SQL Server database when it opens. Usually you have to click on the table to activate the connection, but I want to proceed this. Does anyone know of a way I can do this with VBA? I'm basically looking for a way to refresh...

We just recently upgraded our SQL Server 2000 to the latest service packs. I connect to my SQL tables via an ODBC connect using Access XP. When I am in Access try to update a recently added record in two of my main tables I get a write conflict error that says that the record has been updated...

I would like to be able to close all the forms in my database when the ESC key is pressed. So, if a form is open and I press ESC the form will close. I have quite a few forms in my database, so I don't know if I need to insert some code in all of them, or if I could use a module? If you could...