Search results for query: *

I have a table with a bunch of districts where the fieldname is DistCode. I have a select statement as follows: SELECT distcode = 'sta' from tableDistCode What i want to do is replace 'sta' in the results with 'state', how can i do this. Thanks

hi, I have a form that allows a sort of dynamic filtering of a subforms recordset. On the main form i have various options to filter results that are displayed on the subform these options are things like part numbers, dates, employees, etc. What happens when options are selected off the main...

i have a form that has several options (cmboboxes, text, date and time picker) and depending on what options are select a make a sql string to query a table. my problem is when i add a between dates criteria to the string it breaks. here is an example of a string that wont work, it states...

I'm have made an asynchronous client/server program using sockets. I am trying to update a listbox when i receive a message but i keep getting an TargetInvocationException on it. I have the method i am using for this on other controls and they work just fine, its just this listbox. What...

Im trying to update a table from three different excel tables, so what i have done is a union query to get the information i need from the three tables into one query table, Bulk Import. What I'm trying to do with the information in Bulk Import is to update/add to another table Tools v3. I want...

im try to create a automated batch update feature to one of my tables. What i have is a table, Tools, that consists of: serial, size, date_serviced, status, employee. The excel file i need to import can be called xlTable, but it contains too many fields; tool serial, serviceID, size (inches)...

-MS Access 2002- Im trying to create a form called 'update tool' that will take the values, Employee (number), Serial (text), Size (number), and compare the serial field of the form 'update tool' to a table that holds all of the serials, 'Tools'. So what i have for the 'on click' property of a...

i have a form that is tracking some parts, and the user will enter a machine name, the new serial number that is going to be used, and the old serial that they are bringing back. What i need to do is automatically update the status of each of those serials. The table that the form is bound to...

im trying to calculate how long a tool was used in a certain machine. so what i have done is i have made a query that brings up the all the records for all the tools in a certain machine along with the dates that they were installed. so im trying to take the first date from the query results (i...

I am having an issue when i try to use some alphanumerical data. I have to track some parts by a serial number (ex. a596) so they way i have it set up right now is you first enter the new serial and it will save to table1 as type text. The update info is saved in table2, which is also set as...

I just was assigned a project of developing a database for inventory tracking as a summer intern, and I have been researching information on databases like no other. Ive never developed one on my own before so everything I know so far i have just learned. The question i have is, i have decided...