Search results

Hello I am just starting a business from home for Computer repair/software/hardware upgrades etc. I am designing a database to record the work I do and to provide the customer with a receipt for the work. The work would be itemized in a form (much like an invoice you would receive). I have a...

Hello I have a db table that contains 6 columns I am trying to build an update query from the table The first time strSQL runs, the data would be inserted into field(1) The next time it would be inserted into field(2) etc... When it runs, I get an error saying there is no destination field in...

Hello I have a series of variables ( var1 - var20 ) I also have txtboxes numbered txt1 to txt20 I am trying to set all the variables to 0 by using a for loop dim x as integer dim c as string for x = 1 to 20 c="var" c & x = 0 next x This does not work for the txtboxes: for y = 1 to 20...

Hello Is there a way to find the top n values in a table? I know I can find the top n in a field, but how can I search the entire table to find the top n values in the entire table? Each field in the table could have the same values as the other fields Thank you Terry

Hello Scenario I have 5 fields (F1,F2,F3,F4,F5) I have numbers 1 through 100 that could show up in each field. Each row will not contain duplicates, but there could be many instances of the same number for the full scope of the recordset. Ex: Number 5 Exists 10 times in the 5000 records...

Hello Is there a way in Access 2003 to convert a number to the typed value for the number? Ex: Number: 1 Converted: One Number: 55 Converted: FiftyFive (or Fifty Five) Thank you Terry

Hello Is there a way to take an array, parse the values and then based on one value, add the corresponding values to a count for each record? Ex: Lets say a pizza place wants to track their toppings; which topping are chosen with each other topping. Tomatoes, Peperoni, mushrooms, extra cheese...

I have an Access DB with Printer IP's, Hostnames etc. One bit of functionality I would like to be able to include is this. I can now lookup the Hostname of a printer by IP address. But what would really make this db functional is if I could find out what actual port the printer is plugged...