Search results

I have a query which shows records from a table. Then I have a second table linked by a common field, with a criteria. The criteria that I want to use for a record is that a linked record in the second table is NOT present, OR if it is present, then a field value in that record is 4 or 5. I...

I have two forms that are not linked. A barcode is read on one of the forms and I want to transfer that barcode data to the second form, to avoid having to scan the barcode twice. This works fine as far as it goes. I use IsLoaded to make sure that the second form is loaded, then transfer the...

No the table has three fields. I skipped one in my initial description. This does not appear to work, so I did a work around. I made a query in which the country codes are the first field, and so it works. Robert

RowSource: Country Codes That is the table name. Should I change it to a query? Robert

Rowsource: Country codes, a table with three fields, COUNTRY, CODE and APPROVED (a yes/no field) Control source: O_CNTRY. A text field in a table. Column count: 3 Column widths: 1";0.5";0.5" Bound column: 2. But no matter what I enter here, I always get column 1 in the control. Robert

I have a table of countries and country codes, two fields. Then I have a combo box in which the user selects a country, and the country code gets applied to the control. However, it does not work. I am entering '2' in the Bound Column, but what gets selected and put into the control is always...

Some good suggestions. The format of the partial / complete part numbers I gave was just an example. The actual part numbers can have any combination of letters and numbers. 2 to 40 characters. So sometimes the 'partial' part number is the whole part number. Sometimes it is just a few...

I have two tables. One table contains partial part numbers, and the other table contains complete part numbers. For instance, the partial might be 'E123' and the complete might be 'E123-A1' and 'E123-A9'. What I want to do is to see all of the complete part numbers that contain the partial...

Ginawhip: Can you remind me how to access references? It's been a while since I did that. I tried this: In a code module of a form, I selected Tools, then References. I got the error message 'Error accessing the system registry'. Robert

That function is already in my module, exactly as you show it. Robert

Function SetPropertyDAO(obj As Object, strPropertyName As String, intType As Integer, _ varValue As Variant, Optional strErrMsg As String) As Boolean

Yes, I created a new module called GKDAO, and in that module I put Function SetPropertyDAO, and Public Function HasProperty, as that is called by the first function. My problem appears to be with 'db' in my call to SetPropertyDAO. Don't I need to declare db somewhere? Robert

Ginawhip: OK, I created the module and that seems to be fine. But now I am getting an error message on SetPropertyDAO(db, on the db. The error message is ByReg Argument type mismatch. So presumably I have to declare db. What do I declare it as? Robert

Ranman: I ran the code, but I got an error message on 'Call SetPropertyDAO'. The error message was 'Sub or function not defined'. What do I need to do to define the function? Is there a library setting? Robert

Excellent! Now, if I want that to be set one time while the program is running, where do I put the code? Robert

Some of my users run the program with 'Display Document Tabs' set, and some do not. I can identify those users that do. They lose this setting every time I send over an update. Is there a way to set 'Display Document Tabs' under program control? Robert

Yes, I am recording the time that the record is posted. I could use Now(), but that gives a date and time. Is there a way I can just query the time in Now(). I don't care what the date is. Robert

I have records that are posted at many times of the day. At present with just a date. I need to be able to count those records that are posted in 'overtime' - after a certain time. Can I do that? I know there is a date and time option for a control. Is there just a time option, that I can...

I have a form with several subforms. Based on a condition, I want to make one of the subforms NOT appear when that condition is true. How do I do that? Robert

That's very helpful. Is there any way to send this without using SendObject? I have had many crashes after sending emails with SendObject. The email is sent, and then Access freezes. Robert