Search results

I had a plan to make tables relationship as one-to-many but the thing is the equipment type will have unique ID but manufacturer cannot be unique as a single manufacturer can make multiple equipment type. So I can make a one to many relationship between equipment type and manufacturer but i cant...

Hello there, I am trying building a filter using three list box and they filter down at each selection in the list box. Requirement: List box:- 1. Equipment type 2. Manufacturer 3. Model When the user selects equipment type the manufacturer list box should show only manufacturers of...

that did the trick...Cheers mate!!!:D

Its on the lost focus event of the dateofbirth textbox, but the code doesn't work when I enter a date below the year 1990. Is there a format I need to follow to use a specific date???

Hello, I want a vba code that checks the date and if the date is below 1-1-1990 then it should open a form. I know a bit of vba but I cant figure out how to enter the date in vba If me.dateofbirth < 1-1-1990 then DoCmd.OpenForm "helloworld" end if Also which event should I put the code in...

I tried the wizard, I set both the columns in series part and I didnt change or alter the axis..I get 4 bars but there are only two columns and also the X axis is North South west..

hello, I'm new to making charts. Basically I have a table with two columns called Order Received Date, Order Delivered Date. I want to make a Bar chart that shows the number orders received and delivered in a month. I want to do so without any additional columns. I want the columns in bars...

It worked but when I move to the next record which has the check14 unchecked but the txtbx is still yellow..tried pasting the code in before and after events..no luck..:banghead::banghead::banghead:

CHEERS MATE!!!!!!!!!Finally I can have a peaceful coffee break :D

Greetings, I made a tab control called TabCtl54 which has a pages named hello world and hello earth. I have a checkbox named 14 place on the page hello earth. I placed a textbox called txtbx on the form. Now I want a vba code that would change the backcolor of txtbx to yellow when the...

You Sir are the "ONE" :D

on the desktop, I'll be using this db on multiple computers..how to type in directory so that it can save in the desktop regardless of the user.

I tired this before but it gives an error "Run time error '3051'" Dim curPath As String curPath = "c:\MaintenanceData- " & _ Format(Date, "mm-dd-yyyy") & ".xlsx"

I tired this before but it gives an error "Run time error '3051'"

Its done, quick question will this take space on my db?

Greetings I'm using the below code to export m table to excel and then open it. Dim curPath As String curPath = CurrentProject.Path & "\MaintenanceData- " & _ Format(Date, "mm-dd-yyyy") & ".xlsx" DoCmd.TransferSpreadsheet acExport, 10, "Installed Runway Equipment Data"...

I still don't get it, sorry for being dumb :banghead::banghead::banghead:

I figured it out. I placed the textbox on page footer instead of the report footer:p. Thanks you for the help.

its there just above this unbound textbox.

I tried that earlier and its not working...I still get #Error:banghead::banghead::banghead::banghead: