Search results

Has anyone had any luck connecting a signature pad to access without having to buy 3rd party software? Is it possible? I was helping to clean out an unused office here at work and found a Wacom STU-430V still in the box but with no software. Wondering if I could put it to use and get...

I need some advice. I have a database that tracks visitors to our company. I started with a search box that will look up any info entered from the records of previous visitors and show any record that has that info. You can also just enter a NEW visitor. The problem is the search field is...

Morning all, I've been asked to import some excel graphs to display on an access form. I haven't found a way to link to the actual graphs in the spreadsheet so I linked to it as a table. I am trying to recreate the graphs in access but what I want to know is if there is any way to...

So I'm stuck with something that should probably be easy but I can't figure it out. I want to open a random picture named 1 to 50 once an hour. Easy enough, but I need to not use the same picture more than once in 24 hours. When I open the picture I update a record in the table of the last...

Hello all, I'm curious about keeping a set number of records in a table. I have two tables. One with 40000 records and one with 90. The 90 are also in the 40000. I have a button on a form to delete records, selected in a listbox form the 90 record table. I'm curious if there is a way to...

So I have a list box and 6 buttons next to it. I'm trying to make the buttons visible or not based on whether there is something in the list in that row. My buttons are named REC1 thru REC6 and are tagged logistics but I can't get this code to work. Any ideas where I'm going wrong? x =...

I have a form with 10 yes/no controls. The value of the 10th will be yes IF the value of all the other 9 is yes else 10 will be no. My question is can I use tags, or some other method, to look at all the controls rather than create an if statement calling out all nine controls with and? Is...

I've recently encountered a problem with a stuttering network. The network loses connection just long enough to crash the front end of my database when a form requeries or does any update. So my question is this. Is there a way to suppress the inevitable bevy of messages about it and just...

Morning ladies and gentlemen. I have a query with 27 fields. they can be "p", "q" or null. I'm trying to create a field that will give me a yes or no based on whether ANY of them are "p". I've tried this firstdone: IIf([a101] And [a102]="p","no","yes") which works fine until I hit a null...

I'm curious, if I have a subform with a listbox that looks up a value. So in the listbox the criteria for that field is [mainform]![subform]![control]. But what is the best way to make that subform usable on another form? It's easy enough to just make a copy of the subform and set the...

Here's the challenge I have. I import data from an excel spreadsheet to one table called tbl_pendingschedule and add a yes/no field called scheduled. Then I have a form with two list boxes. The left one is all the units in tbl_pendingschedule with a no value in the scheduled field. On the right...

Hi guys. I'm having a problem with an update statement. It should set a yes/no field to yes but it asked me to "enter parameter value" when run. Do any of you see anything wrong with this statement? For x = 0 To Me.zlist.ListCount - 1 If Me.zlist.Column(5, x) = False And Me.zlist.Column(6...

Hi, I would like to put a report on my form but I want it to display on the form in print preview mode instead of report view mode. Is this an option somewhere that I am just not seeing?

I have a field that saves minutes and seconds past a time limit as negatives. So my field has a value like -02:23. Now my question is how can I get a sum of the negative numbers on a report? Is this even possible? I have converted positive numbers to seconds, totaled them, then converted...

I have a form that the on open event sets a couple of values in text boxes depending on what time the form is opened. This works fine when I open the form through a button click but when opened through vba it doesn't set these values. Any ideas why it only skips it when using vba?

I have a form called frm_ppi with a button to open subfrm_calendar. It works great.... But if I putt ppi as a subform of another form then the button opens the from but shows no data. Is this something normal? I just noticed it today and thought one of my tables had lost everything. I can...

I am trying to set the backcolor of a control based on whether or not that control shows in a list but I am getting stuck. I get a cannot find field error when I run it. Any idea what I've got wrong? For x = 0 To 30 'If Me.List61.Column(4, x) = "AM060" Then Me.AM060.BackColor = 255 If...

Okay guys, I'm having a brainfreeze. I have 2 tables. Parts and supermarkets. Supermarkets has 42 records. One field is superdesc and another is smname. Parts has thousands of records and they all have a superdesc that matches the Supermarkets table but no value in the smname field. How...

Ok, I'm stumped! I have this in my timer event If Me.chkdone = True Then Me.Command170.Visible = False Me.Command171.Visible = True Else Me.Command170.Visible = True Me.Command171.Visible = False End If and it hangs on the first line saying it can't find the control. I can rem out these...

Is there a way to set the focus to a specific text box when using a scanner? For instance, I was told today that a scanner wasn't entering data into a field. No, it won't when you're focused on facebook! Is there a way I can tell access that when the scanner trigger is pulled I want that data...