Search results

Could I create a 1 by 3 array and then use that array and compare it to the winning combinations 1 by 3 arrays? If so how would I go about doing that?

Let me explain. When you spin the slot machine a random number is created for each wheel. those random numbers repersent a picture. So if I click on spin the result would be 3 numbers, for example 3 1 2, where the 3 is the left most wheel, the 1 is the middle wheel and the 2 is the right most...

is there a way i could use arrays? The problem im having is that each wheel has a random number associated to it and that number displays the picture. I need to take all 3 numbers and put them together to form a one by three. here is some of my code for one wheel and one pic Dim...

I am building a slot machine game in access. So far i have a semi functional game. When you click on the spin button, 3 slots spin and display random images. My question is I need to write an algorithm or some sort of loop to determine the winning combinations. Below are the winning...

Im wondering if there is a way to create a delay. If I had multiply images and I wanted to display them for a certain amount of time on a form, how would I go about doing this. thanks in advance

I have a combo box that lists account numbers for clients. I also have a directory on my hard drive that contains Dymo label files with the clients account number as the name of the file. I would like to select an account from the combo box and click a button to open the Dymo label file that...

I have a table that holds customer information. The table uses an account number for the primary key. The table is becoming quite large and the only way to print out a equipment loan report for an account is to use the record selector. Is there a way to enter the account number and bring up the...

I have a combo box that uses a query to display account numbers. I also have a textbox which I would like to display a requestors name. The requestors name is associated with the account number. so when you select the account number, I would like the textbox to autopopulate the requestors name...

I have a table with ProductID, Quantity, and DateUsed I want to pull out the total number of products for a specific date range. Here is the query I have so far SELECT Count([InventoryTrack].[Quantity]) AS Total FROM InventoryTrack WHERE ([InventoryTrack].[Productid]="110"); The output is...

-5 will always be the case

I have a query. UPDATE Product SET Product.[In Stock] = ([Product].[In Stock]+1) WHERE ((([Product]![ProductId])=[Forms]![Main Menu]![txtBarcode])); What I want to do is use the 1st query but I want to use the Left$([txtBarcode],3) to substitue [txtBarcode] Thanks in advance

both textboxes are conected to fields in a table

I have two textboxes txtPrep and txtInstall. When the user enters an install date, I would like the txtPrep to display the txtdate - 5 days. So if txtInstall = 10/6/2004 Prep date would = 10/1/2004 Thanks in advance

I have two Forms: The Main form and a warning form I have a textbox on the Main form txtNumber I have a textbox on the warning form txtNumberWarn When a value is entered in the name form textbox, and it is already been added to a table, the warning form appears. What I need is to pull that...

I have a table: BarcodeList Barcode Number 'string Status 'String Barcode ID 'autonumber Im trying to write a query that will select The barcode number that has the greatest Barcode ID out of the tabel. Here is what I have so far SELECT [BarcodeList].[Barcode Number] FROM BarcodeList GROUP...

Actually the beforeUpdate did work. Thanks for the help

Yes I have, and it does not work

The Problem Im having is that when I enter a value in the txtBarcode, Access adds that barcode to the table BarcodeList before I get a chance to search for the barcode. I want to be able to take the number entered in the text box and check the table first before updating the record Whats...

I have built a Barcode scanning program and Im having trouble with a part of the functionality. What it is supposed to do: A user will scan a barcode and that number is stored into a table if it is unique. If it is not unique then I want to open a new form. This is the code I have for the...

Here is what I want to do Im writing a barcode scanning app and my problem is that when I scan the item I want to bypass the duplicate error message. I am trying to to run an SQL statment that will search the barcode table before the update to check if that barcode is being used. If it is I...