Search results for query: *

Why not import the table to the server as is? Then set up one more table that has Code1, Code2, and Code (a map or ownership table) showing the relationship between The other codes and your categorization. Then build your final output view on the server using this SQL:<br> <br> CREATE VIEW...

There are so many ways to do this it's hard to pick one. Since you're dealing with character data you can do whatever you'd like depending on how the dates have been entered. <br> <br> 1. Create a new field in the table and populate it using an update query that employs the CDate() function...

I worked with an Oracle 7.3 back end for 4 months recently and you don't talk directly thru ODBC. You have to go thru a layer called SQL Net. This introduces some challenges if you're used to dealing with data on SQL Server. For instance, we were linking to tables on Oracle and SQL Server and...

Pretty wide open question. You can do it, but because Access doesn't use true record level locking it can get dicy. I tend to use mostly unbound forms and control the population of all objects. I also use arrays as sources for list boxes to improve performance and avoid some record locking...

If you're using Set db=CurrentDB to create a local database object then you need to close the instance of that object when you finish the proc. When you close the db it will close the recordset for you, but not vice versa. use:<br> <br> db.close<br> <br> If you don't, and you're doing this...

I think you want to choose SQL Server login in the DNS setup wizard. This will cause the user to have to log in to SQL server. If you have permissions set up for users/groups on SQL Server then the user should be able to log in as a user or group regardless of whether you specified Machine or...

Easy to do in a report, by creating a recordset and calculating the running sum, or using a maketable query and doing an update. I don't think this can be done in a one off query to produce this result.

Just dim a control object called lst and in your select case statement instantiate the appropriate list object.<br> <br> Ex. Case 4<br> Set lst = me!Listbox4<br> <br> Change all the "ListBox" & ctr &... to lst.<br> Then add a line at the bottom as:<br> <br> lst.requery<br> <br>...

Look at Access, Office VB issue 9902. Editor Ken Getz (co-author of The Access XX Handboook series) gives a great rounding routine. This mag is a great reference for dev tips and is well worth the $$.

I'm not exactly sure what you're trying to do, but you shouldn't need to append the First, Last, etc. if that SSN is already available in Employees. Just pop up the name of the Employee on your form using a dlookup() command and show the system operator who is calling (you don't need to bind...