Search results

thank you for your suggestion! Much appreciated

Here is the code I inserted for OnError Event for the Form. It worked but I have not idea why as I am not sure what "Case" means. thx for your help Private Sub Form_Error(DataErr As Integer, Response As Integer) Select Case DataErr Case 3314 MsgBox "By Whom...

I put the code into the OnError even field and when I compile the code I get an error msg "Compile error: Variable not defined" and it is highlighting "Cancel =" Any suggestions?

I put this code in the OnError event box and the result I get is the program advising that "Cancel" is not defined... Private Sub Form_Error(DataErr As Integer, Response As Integer) Dim JPGopher_ID As Control For Each JPGopher_ID In Me.Detail.Controls If...

Yes, I was using it at the suggestion of MajP because he sent me this link with a code to reference.... https://docs.microsoft.com/en-us/office/vba/api/access.form.beforeupdate(even)

Attached (form_fields.jpg) to show the names of the fields that are reflected in the error messages below... I went to the form level, copied the code and inserted the name of my control [JPGopher_ID] for [oContr] and when I click on anyone of the 5 buttons in my BYWhom box, I get (4) msgs...

I'm still new to Access, so can you give me an idea of what type of expression I should write? thx

I have a table with a field, [Job Process].[JPGopher_ID], which requires a value in the field. The form I have developed for my users has the label, "By Whom" instead of [JPGopher_ID], which makes more sense for the users. Unfortunately, the error msg that pops up (see attached .jpg) states...

I appreciate the suggestion about avoidng spaces in object names. Unfortunately, I wrote a lot of this program YEARS ago when I didn't realize spaces could become a problem. Too many changes would have to be made and I haven't really run into any issues.

That did it! I changed the JOIN between [specjobs].[firm] and [Architect].[Firm] to "All records from 'specjobs' and only those records from "Architect' where joined fields are equal." Thank you very much!

I have set up a simply query as shown in attached (.pdf) [specjobs] is my main Project database, [Job Process] is where the users put their project notes. [Architect] is a database containing Architectural Firms that would be involved in the design of the Project The way the query is set up, I...

I think I fixed it. Apparently my query wasn't running correct. Thx for the help

I have never run into this issue before today. Please see attached (.pdf) I have imported data from Excel into my existing database as a new table. I take the data from the table and have to modify it somewhat to use it properly. One field is [ASI_mfg]which can have any one of (9) different...

Food for thought, Micron. I will re-evaluate my approach because what you are telling me makes a lot of sense. thank you

Gasman: I could do that "behind the scenes and might in the future. However, the users are currently trained to do both at this time...want to keep changes simple at this point in time.... lol

Gasman: I will give your suggestion a try and let you know how it works. thx!

Actually, not a dumb question at all, Micron! That is the way I have things currently set up. Both the click box and the text field are used for different reasons. Rather than have to do two things, I am just trying to ensure that once the click box is checked, the text field is automatically...

I have written the following code which accomplishes what I want. Private Sub JP_Special_Lite_Click() If Me.JP_Special_Lite = True Then Me.JPMfgOnCall.Value = "Special-Lite" Else Me.JPMfgOnCall.Value = Null End If End Sub When JP_Special_Lite is Clicked, the value...

See attached (.jpg) I would like to have one field filled in with a specific text depending on which checkbox is clicked. In the attached example, I would like the [Which Mfg] field, filled in automatically with "Special-Lite" when the [Spec-Lite] checkbox is checked. If the [Select] checkbox...

Thank you for your reply. I do make a backup by copying the .accdb to a different drive every night. The issue is when I opened up the backup the next day and I tried to open it by running my initial macro to start the program, their weren't any macros to choose from. In searching futher, their...