Search results

I have a sub form that om a timer will run a playsound file, on my main form I have a button that i want to stop that sound from playing till my timer hits 0 again. Anyone know how to do this would be great

Ok so I was rethinking this what would be the easy way to have this info go straight to a table. Then I can use a query to get the info back from the table.

I have a form with a command button with on click: Private Sub Command6_Click() Dim ID As String Dim TT As String 'tt=time Dim DD As Date 'dd=date TT = Time() DD = Date ID = fosUserName() Forms![frmMain]![Child9].Form![Hash] = ID Forms![frmMain]![Child9].Form![Date] = DD...

I stripped it down no pics or some files but when you click inventory I need a easy way to add keys

Im trying to send the db so you can see

bound its a inventory db so one of the fields in memory stick so the user would put the serial number in that field. The problem is the keys there is multiple

Ok my form has multiple fields when a user like memory stick they put the s/n in that field now it is in the table under there name. But if they have keys they have let say 10 how or what would be the best way to enter them in on this form. I tried a combo box list box a field nothing i would...

I have a db with 3 tables one is the employee table one is the inventory table. When a user logs on and goes to there inventory there are about 10 field boxes linked to the inventory table via a query. My problem is all of the inventory is one item but there is one thing there keys they could...

Works great thanks

I have a simple timer that looks at actual time and date and looks at time and date in table. If = msgbox opens wont work something I'm not seeing with the time.

Private Sub Form_Timer() If Me.[Time] = Time() And Me.[Date] = Date Then MsgBox "Send AQIM", vbYesNoCancel, "AQIM NOW" End If End Sub

Ok i put that cade in the timmer and now everytime i open that form the message box pops up and i cant get ride of it. If I get ride of all the data in the table it wont show but even if the time is diff the box pops up

This will only be running on one computer and thats what i was thinking repeat that little code once a minute. where do you think i should put that code and is that even a good way to do it.

Ok what im looking at doing is I have a list of times and dates when that date and time come up I want a way to alert a person that is at that computer to do something. I was thinking a message box that pops up would alert them. Also I do see that error [fmdata] it was to be [frmdata] but still...

Hello im trying to make a msgbox pop up if the date and time are the same as the ones on a form. What i have been trying is this If Time() = [fmdata].[Time] And Date = [frmdata].[Date] Then MsgBox "Send AQIM", vbYesNoCancel, "AQIM NOW" End If Nothing happens any help would be great thanks

I want to say thanks for all the help so far the reason im doing this is the more fields that match i want to rank. if a records fields match in more then one field that would give it a higher ranking.

What my problem is when the first query runs and looks for same in t1 to t2 i need to know what it hit on was it the doc or name. but also show the rest of the record so the name could have multiple hits but diff doc numbers. but i need it to show the other doc numbers but let me know it hit on...

Ok so is t3 the table that is made from the query and im looking for a match to table t2.

But how would I tell the form what field made the record

Let me ask just one more thing well this time when I run the query it gives me the whole record. What I would like to see is if its hitting on the first name, last name or document number I would like a indication on what one. maybe that field would be a diff color or something.