I have two tables, one with resident information (names, birthdate, etc) and then another table for emergency contact info for each resident. The resident PK...

we have a medium sized db and pictures (stored outside) are part of it. the question is this; does anyone know of a means to auto resize the pictures for use...

Following a crash while using one of out Microsoft Access databases, the following message appears everytime we try to open it. "The Microsoft Jet Database...

Hi, me again. Its been a long time (as you can prob tell) since I've done any coding but I remember years ago when doing VB that there was a .top reference to...

Dear all. I have two tables containing a Date column: ---- purchase_tbl: date_clmn Date Short_Date curr_clmn Number other1_clmn Text other2_clmn ...

Hi, I have a query which looks at a form and searches between a range of dates. The expression I've been given to put into my query is as follows: WHERE (...

I turned off the default menu bar and toolbar from my access database through the Tools/Startup Options so it only displays the switchboard system...

I have a sort of one-off need to be able to type a formula into a database field, as a string, and then execute it later. The formula would be something like...

How can I make a field (bound or unbound) box in a form, produce a colour background when the user types in say a date then exits the field box? Basically...

Greetings and thank you! I am performing a very simple insert into an MS Access DB located on a Microsoft server hosted by GoDaddy. For the sake of testing,...

I am looking for learning resources for Access forms. Does microsoft or any other site online offer such?

I have used Set Database password to secure the Backend of my application. The problem is that when I try to open the Frontend I dont get an log on screen in...

Please Help! I'm trying to automatically close a form if a field value on that form is null (meaning there are no records in the underlying table) I tried...

Hi, I have a list box with several columns and the Rowsource is a query. I would like to pass into variables the information contained in each column of the...

I'm trying to close a form if there's no underlying data in the table. My code: Private Sub Form_Dirty(Cancel As Integer) If IsNull(Me.Old_Check) = True Then...

HOW DO YOU USE THE MINUS SIGN WITHOUT IT BEING PART OF A FORMULA

I am trying to set a form that automatically is filled in from data from another form. or as the data is filled in on one form it is also filled in on another.

Is there a way for a button to be palced on a fill in form so that once the data is entered that info is sent to another form that has all the info entered to...

The default print range for printing forms in Access is to print all. I would like to change the print range default so that selected records are printed. ...

I have a lady within my company that would like to publish a Microsoft Access Database to our internal intranet web site. She would like this database to be...