Search results

I am trying to use the double click event of a listbox to open a form to a specific record. The problem I have is when I double click a record, Access pops up a box asking for PONumber (which is in column 0 of the listbox). Here is the code that I am using: Private Sub...

This is a wierd problem, at least to me. I used the report wizard to generate a simple report. It simply pulls a list of customers from the customers table. In the customers table, the CustomerID field is my primary key so no duplicates are allowed. When I view the report, however, the...

I'm having trouble clearing a form and the query results at the same time. I have a list box that is populated by a query that gathers search criteria from user input in unbound textboxes. If the user types in criteria, then that is used in the query. If they just click search, then all results...

This is probably failry simple if you know what you're doing, but I don't know what I'm doing.... I have a form (Purchase Orders) and on that form there is a search button to allow the user to search the customers table by customer name. When the user clicks the search button a search form...

Has anyone around here successfully implemented the Crystal Reports Viewer Control from Access? I have the Viewer control placed on a form, but from there I'm lost. The instructions I have say to set the 'ReportFileName' property to the path to the report, but I do not even see such a property...

I know I know, another Dmax/Dcount question. :mad: I didn't want to ask it, but I just can't figure out why my Dmax/Dcount statement won't increment. Every time the string is combined I get a value of 1 from Dmax/Dcount. I have tried both Dmax and Dcount and I get the same results from them...

I am trying to create a product code based on the text that is in several different text boxes. I have a product name (W22) a manufacturer (Stuff Manufacturing Inc.) and a product type (Wiget). I would like for the product code to be a combination of parts of all three. The result, for example...

I'm just curious. Input masks can be put on a text field in the table or on the textbox of a form. Is there any advantage to masking one over the other?

I have a form named frmProducts and on it there is a field for the name of the product supplier. Beside the supplier there is a button named cmdViewSupplierDetails that is supposed to open a form with the specific supplier's details. Somewhere on this board I found an example of this (the...

Okay, like hundreds of other people around here I'm not an Access guru and I have a problem. :p I am trying to calculate the time between two dates that are split between four different fields. The form fields are DownDate, DownTime, UpDate and UpTime. I'm using four fields because I need for...