We all know that Access mdb apps bloat with use and must be compacted periodically. I think I read somewhere why this happens but I can't recall. On an app I...

I have a workorder form which has a Combobox, which generates all the information from a customer table. How can i put a message box that will ask the user if...

Hi Is it possible to somehow jump to the approximate middle record on a form via code? Thanks Regards

Alright I was successful creating two combo boxes that are now synchronized. Thank you...I referenced Microsoft help "Basing one combo box on another. Now I...

I have a form that lists the donations history for a donor. I would like to have 2 subtotals - one to subtotal the donations for the current year and one to...

hi i've got a few forms which are backed by ado recordsets and i load them on the forms OnOpen event via vb code in a common module. to clean the form module...

I have a ListBox (its record source is a qry) on a Main Menu; it contains 2 columns (LocationID & Budget%). It displays records where the budget% is at a...

Originally I asked a question w/ subject "Cancel Command" My question has greatly changed so I'm sending this: PLEASE Help me fix the TYPE in the below...

I have coded the text boxes on a form to color when no data is entered. It works great on my system, however, when another user opens the form. Where there is...

I have a main form with a subform linked using VendorID. On the subform is a combo box PartNo which gets its data from a query which includes a table tblParts....

I have worked through my whole query and found that this is the specific clauses that causes the problem. I have read some comments that subselects...

Could someone please help? I am using the 'defaultprt.zip' tool provided by Ken Getz to change the default printer via VBA code (code below). My problem is...

I am trying to use conditional formatting to colour code a last contact date field (txtLastContact) as follows: Date falls within the last 6 months -...

I have two option buttons (yes/no) on a form that I want to show cleared with an option to select them (place a dot in the circle). The buttons default to a...

I am trying to control the colours in a continuous form - eg if a number has a negative value I want it red if positive value black - I seem to get all red or...

I was wondering if there is a way to open switchboards (or forms) according to the user... I know how to create switchboards or how to create a form and make...

Hi Experts, Sorry for the "subject" if it doesn't make much sense. The issue is: Need to design a form for pricing selected items and quantities...

have a workorder entry form where we are entering multipule workorders the same date. any idea's how to repeat the date value from the previous...

Hello all, I'm in the process of creating an inventory database and have encountered a significant road block. I have a form/subform problem where I have a...

i am new to access and i am trying to base 1 combo box on a certain selection in another combo box. i dont understand vba though, is there an easier way?