Hi , I'm wondering if there is a way for me to export some tables including data and structure from old database to a new database and then save as new...

Dear all, I had a problem with the Access2003 database. Users use an access database in a server's share folder in the LAN. When double click a form in the...

G'day, I have a form based on my table "tblclient". This form is data entry only and I would like to include a command button that when pressed opens a...

Ok, I have looked at this and customised it I think correctly, do I put the code under the click event of a command button? Sorry new to this and getting...

Hi All I have a combo box with is linked to a column in a table. This column can only have the values that are already listed in the combo box. How do I...

Is it possible to create a save and exit button within VBA?

I am converting a spreadsheet into a form/database...in Excel the original spreadsheet had each date of the current month listed with how many times on any...

Hi guys. I need some advice. I've been wasting a lot of time trying different approaches, but I thought I'd ask some experts for opinions. I have a Form...

I have seven text boxes with calculations in them on my form. I'm trying to get the highest value out of the seven to turn red. I used the conditioanal...

Hi All, I want to restrict the number of records displayed on a main form so that I don't have to wade through hundreds of records for which there is no data...

Hi I have a form where certain fields that weren't required fields before now have to be mandatory. I have changed the Required property to yes in the bound...

Hi, I've got a subform displayed as datasheet, with 1) a field "limitless" that's a checkbox, locked, maybe true or false (duh!) 2) a field "limitDate" that's...

Last January this group helped me come up with an event procedure that automatically assigns project numbers in my form. I use this in the BEFOREUPDATE event...

I am using a listbox to gather multiple columns of a query. Originally, it was designed that many rows could be returned, but now only 1 row will ever come...

Hi! I have a couple issues with the TreeView control I'm wondering if any of you would have an answer on. Issue 1: When I use the drag/drop feature, the...

Within my database, there is a table called Property_Numbers which stores available property numbers and has a Yes/No box which identifies if the number is...

what's the best way to create sort buttons (in the design) of a form to sort the various fields in either ascending or descending order???

I'm really stumped by this problem... I created a Form1 with Query1 and the OrderBy was set to Date1, I presume because Query1 had such a sort. I added to...

I have create a form and a button to send emails. The button has the following code behind it comes back with an Error. The Field that contain the email...

My user does not want the 'next' button on the navigation toolbar to position on a new record. Is there a way to gray out this button when I'm positioned on...