Search results

I have a cashbook form which has two sub forms. One based on a query of the cashbook table, for the amounts IN and another Based on a Query of the cashbook table for the amounts OUT. When there is a day with no records on one or both sides I cannot get the "Total" Textbox to return Zero. Just...

I have a line of code : CIT = DLookup("[SumOfAmountIN]", "TotCBINS") which looks in a recordset of a query for the total cash entered. If there is a day without entries (Possible) then the query has no data and I get the error "Invalid use of null" How do I get round this as there could be...

i have a cashbook table and after cash up the Balance Carried forward is added as an entry. I need to be able to select the last BCF amount , after a weekend or holiday so i can not rely on date -1 as it may be 3 days ago that the till was last cashed up! can anyone offer a suggestion? I have...

I have a stand alone DB on my pc some times on shutdown i get a message "Table 'TempMsSysAcessObjects' already exists" what is that telling me i should do...am not doing right.

Can anyone tell me why a BMP Image, which I have put on a report, is Printing in Black and White when on preview it shows in colour. It is not the printer ink because the same Bitmap image on a Form, prints in colour?

I have a report based on a Single table select query, which has a function in the criteria to obtain the customer number. the query runs fine alone. eg selecting the right record for the number and displaying the name and town...however when i open the report it runs on..That is it displays more...

I have a form where the user eneters 2 dates. I want to beable to check if the dates are mon-fri (making weekday) or sat & Sun making weekend. Well I also need to know if the period starts on say friday and ends on monday. so i can prompt user that a weekend is included. If anyone has a cool...

I have a query based on one table (Customers) and two other queries. (Orders) and (Invoices) I have a function in the criteria of the new query which selects the customer but the results are repeated ! For 1 invoice i see 6 records of the same invoice. Is it anything to do with (Output all...

OK I know its possible to mail reports etc but it seems that the user will always be aware becase either Outlook or Access pops up a send message box. So if you just want to send a message e.g. "Till Cash does not Balance with Cash book" Does the user have to be aware? Appart from the fact...

I have a form with 8 textboxes which are unbound and have calculated values. Can I sum them. eg text1 to text8? How?

I've been trying to get this and am missing something. Reading others threads I get the idea that its possible to send a report using code something like this. DoCmd.SendObject acReport, "CanInvs", snapshotFormat, "email@wherever.bla" My debugger wont have it but i cant see whats wrong. This...

I have a form which has 3 buttons. onclick each button sets a variable strDur to a respective vale 1,2 or 3. My code calls the form using Docmd.open form The form Opens But before I can click a button the code continues to the next step. I want to wait until the button has been selected then...

I Have a form which hosts 2 sub forms both based on different queries. I Had to add two Fields to one of the tables which one of the subform queries is based on. After doing that My Host form will not open and I get RTE 2501 "The OpenForm Action Was Cancelled" Any Suggestions? :(

Why Cant Access find my form? 1. It does Exist in the DB - I can Openit from the DB directly and I can see it in Project explorer. 2. The spelling is exact - I have checked this >= hot diners. 3. I have used the same method to pass an ID to an Unbound field in other forms and it works. :-...

I have a button on a form and ON CLick It Opend a second form which is based on query. The Button is actually on a subform in the 1st Form and it needs to pass a value to the second form when it opens for the query criterion. It was working yesterday but I went on too late and changed something...

I have a form with two figures a.(Deposit) and b.(Actual charge) To discover if the deposit was sufficient I take the actual charge (b)from the deposit (a) When the deposit is less than the charge the Result is a minus. eg deposit 100 Less Charge 150 = -50 I want to use that result to say...

I have a form based on a query with a criteria which pops up a dialog box asking for the parameter for the query. It works great unless the user clicks the cancel button...Then The form continues to open but is blank as the query didn't get its criteria, i guess. What can i do to stop the form...

Is it possible to use Dlookup to enter a value into a textbox on a form and then save the value it passed to the text box into a record in a table? Is it also Possible to do the same thing with text box and pass the value to a query criteria? So in the first instance you lookup the customers...

I have a Message box yes no cancel I would like a box which has 3 buttons with caption Morning Afternoon Full day, do I have to create a form like a dialogue box or is there some cool trick

I have an Access database which accepts input from a barcode reader using Inputbox function. However I need to know what one needs to Printout a barcode? Is it just a special printer driver or a whole application. The Scanner worked directly i pluged it into the ps2 port. So I need Advice on...