Search results

Hi All, I'm still learning the some formulation in Access (my head is still stuck in Excel mode). I'm tyring to use the DLOOKUP function (my understanding is this works similar to VLOOKUP in Excel), but I'm having difficulty understanding it. I have two tables, and I wish to run a query...

Hi Alan, Thanks for the suggestion. The only problem is, is my coding in VBA. I created the ON LOAD event in my report, but the compiler doesn't like it. Private Sub Report_Load() Me.Window_Banners_.Visible = False If ([Store Attributes1]![WB]) = True Then <-- doesn't like this line. I...

Hi All, I'm kinda stuck on something. I'm trying to make fields either visible or invisible based on criteria chosen in a form. I have a table with five fields, call "Sign Selection" Field 1 is called "Window banners" Field 2 is called "Theme pennants" Field 3 is called "Exterior banner"...

Sorry if I misunderstood, but I took "you may have normalisation problems" as an insult to my intelligence. I used "Field1, Field2" as examples.

Hi vbaInet, Sorry, I didn't come here to be insulted. Let me put this in more simple terms. I have a report that contains 10 fields. I would like a prompt to appear that will let me select which of those 10 fields I'd like to show on the report.

Hi All, So far, you have all been so much help for me and I thank you :) So, here's my dilema: I have a report (based on a query) that shows Store number, City, State etc, followed with Field1, Field2, Field3 etc. Pretty simple stuff so far. What I'd like, is when the user runs this...

Hi All, Still fairly new to Access events and triggers, and trying to get my head around it all. I have a field called "date_modified" (I know, so original). I'd like to set up an event that will automatically update this field to the current date if any other field in the same record has...