Search results

I have read several posts on this forum about limiting or adjusting the values in a combo box based on a selection from another combo box. I figured the same logic would work if I wanted to set my limits based on the value in a text box field, but I can't get it to work. What I have is a...

This syntax gives me a Run-time error (2001) that says "you canceled the previous operation" There really is no better way (for my purposes) that I have figured out to achieve what I need, so I'd really like to get the syntax for this down.

All, I have borrowed this code from other messages on this forum, and it works, sort of. Me.TrgCode = DMax("val(TrgCode)", "qryTrainingsForm", [ProgramCode] = Forms!frmTrainings!ProgramCode) + 1 What I need to do is tack a number onto a text value into a field that is later used to uniquely...

Here is the macro converted into VBA. Any help figuring out why this is doing this would be much appreciated! When I try to run the break on all errors as pat suggested above, the code dumps me into the Requery"" line. Function mcrOpen_Find_Appl() On Error GoTo mcrOpen_Find_Appl_Err...

This doesn't really help because the event I think is making this happen is running a macro, and I tried taking the SaveRecord Command out of the macro, but it still does it (adds the blank record, that is). The macro is supposed to search for the person in a form and if it doesn't find them...

I have removed this code from the form, but the blank records are still appearing...any other ideas?

Attached is an example of the functions I'm trying to accomplish. Basically, the two tables (tblApplicants, tblInstructors) are one-to-one related to tblContacts, (just a subset of data), however, tblInstructors and tblApplicants are also part of a many-to-many relationship not shown. The...

I have some seemingly simple code on the BeforeUpdate event on a form: If (Me![TribeOrgName].Column(0) < 1000) Then Me![InstrCategory] = "TRIBAL" ElseIf (Me!TribeOrgName = "US EPA") Then Me![InstrCategory] = "EPA" ElseIf (Me!TribeOrgName = "US EPA...

I'm still grappling with this problem...any other ideas?

Also, if it's a consideration for you, if you have any data values for the Time field that falls directly on one of the hours in your criteria (6:00:00 PM for instance), that value will NOT be counted in either column in which it appears. With < or > operators, the value you specify is used as...

You should just be able to run a total query on the first one. for instance: Query1 has incidents and time associated with each one. You may have to set up a calculated field in this query to group the times or say, categorize them (e.g. Time1:[TimeValueField] where criteria is your first...

This all depends on how your query and/or your database is set up. If all the queries can be related to each other or to a master table via a key field, then you can probably set up some outer joins in a query that will count records from each query. This will probably only work if the time...

Yes, I checked that already, there is no formatting on the field in the form or the table

I have a simple combo box that uses a value list: Yes; No; Unknown. The default value is "Yes" in the field properties in the table and in the form. When I add a new record to the TABLE, "Yes" is dislpayed, however, when I add a new record to a form, it displays "-1" (note: the field is a TEXT...

It's not saving the strings ("yes"/"no"), I know Y/N fields save -1 and 0, respectively, the value list is just used for display purposes....I'm not even sure that has anything to do with the problem, it's just figured I'd provide as much info as possible.

I have posted this concern before, but I was mis-understanding what was causing it...in actuality, I don't know what's causing it, which is why I'm posting the question here. Whenever any users enter data into the main table via a form based on the table (not on a query of the table), a blank...

I'm not sure this will work. Which AfterInsert event (on which form/control) should I be putting this? I have tried numerous events to trigger and complete the requery command for the combo box control (tribeorgname), including when the data entry form is closed, unloaded, deactivated, etc...

I have spent so many hours working on this form and search/capture/update setup, and I'm getting stuck on the last few steps. Any help is appreciated, I'm not sure if my answer lies in VBA or not. I'm attaching an example so anyone interested can see how the problems arise. Yes, there are...

I figured it out myself. I guess the ImagePath field in the table needs to be just a text field. I've inserted a field that is also a hyperlink so I can have a hyperlink to open the actual image from the thumbnail on the form.

I've created a basic photo database and read many posts here already on how to do it, so I think I've got it set up right. I have a table with info about the picture that stores a hyperlink for the image path The form displays all this information with an Image frame that is used to view the...