Search results

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...

I backup my MS Access 2007 database every night. When I went to open the copy I backed up on Tuesday night, all my macros, table and forms did not show up! I copied over the macros, tables and forms from my Monday night backup and the program started running again. Unfortunately, when I copied...

The issue only started AFTER I used the Compact/Repair feature of Access. The discussion above triggered an idea on my part and sure enough, for some reason the sub-form on the right was filtering, see attached (issue-w-filter.jpg). Once I removed the "filter", see...

The (B4-Filter.jpg) attached is a screen shot of my main form with 2 sub-forms, one on the bottom left and one on bottom right. This issue I am having has to do with the bottom right sub-form, under "Dodge Status Notes Shown Below" When I work with the data in the main form, many times I...

Thank you very much! That did it

I have a number of quotations that I would like to follow up on and I want to base it on all quotations from the date the query is run, going back one year. I know I can manually set the query up to input a date range, but I'd like the query to run and automatically go back one year. For...