Hi all, I have table in subform control which i have put on a Form call "Main Form". Table name is "Data" and Subform name is "Data Subform". On the Form...

I have a form which receives the input for a multiple entry search. The form then opens a report to show the restricted data. I cannot get it to...

Why does the last line in this code lead to the error message "Overflow"? The figure in question is 33764 which is the value of txtPhotoID before trying to...

$B$*H)$b$D$d$D$d!";E;v$b=B!"855$$=$&$G0B?4$7$^$7$?!#(B $B:#G/$O!"%$%s%U%k%(%s%6$N!"N.9T$,Aa$$$N$GBN$K$O5$$r$D$1$F$/$@$5$$!#(B $BNkLZ$5$s$O$^$@c$$$N$GDq9...

Using Access 2003 SP3 - in Forms I know I'm probably asking a very complex question, so a very big THANK YOU to whomever can help. I am doing a detailed...

I'd like to add a form to an operational database that the users can look at for info on how to use the application; what to do if errors occur; etc. What is...

Quick question looking for others opinions on the subject I develop apps for a company and up until now I have been using modal forms to keep the most resent...

Hi all, I am wondering if anyone out there knows why the wild card (*) will not work in an MS Access 2010 query. I tried, as I have for years, to enter a...

I used to get a warning message before deleting a record. I no longer get a message, it just deletes the record immediately upon clicking the delete button....

Hi all. I have the following issue: I have a query with the following tables: WCust, WFees, and RateType. The WCust contains customer name, address, etc.,...

My table contains a field labled "Case Number" and another field labled "Date Completed". I have created an input form and included code to check for...

How can I add a lookup to a form? Clicking design and going to Data gives me options for functions etc...but not for lookup.....

How do I use SELECT to pull into a form a value from another source based on 2 values on the currenr form and record and where do I put the code? Bennie

Hello Experts I have a problem with printing a record with a sub-form section. I have a "Quotation" form I print and send to customers. The form...

hihi,, I have a button that will load a image, however this button also loads a inputbox.. I keep getting the inputbox 1st and after input by user, the image...

Hi First of all apologies for posting so much code but this is rather involved and I am totally stumped. Basically I have a main form (Staff Batch SMS/E-Mail)...

Here is exactly what I am trying to accomplish: I have a two tables: tblEmailAddress & tblCallData I also have two forms: frmCallCenter &...

In Access 2003, I have a form with four distinct subforms. When I open the main form in datasheet view, the first subform is available as a subdatasheet. 1)...

I have the following line in a button event on FormA: DoCmd.OpenForm "FormB", WindowMode:=acDialog This opens FormB in the EXTREME upper left of the...

Hi, I am trying to change Back Color of some rectangles, but I don't know what "code" is for which color (except black=0 and red=225) in Visual Basic....