Search results

I have a table with a transactionID that has a payment type field for cash and card i.e. ID 1 payment type cash, ID 1 payment type card. These are 2 separate records. How do I create a query where I can identify the ID which has both cash and card payment type? Some ID only have cash; some only...

Can anyone kindly show me how to auto tick or set checkboxes of other records having the same TransID when one has been ticked? Please find attached a screenshot. Thanks

Hi all How does one store the value derived from a combo box to another text box in a form? E.g. Supplier name is a combo box. The combo box has 2 columns, supplier and supplier ID.the supplier name stores the supplier in its own text box. When you select the supplier, the supplierID appears in...

Hi All! I managed to email Access report from MS Outlook generated within the Access application using DoCmd.SendObject. Everything works fine. However, when I use the same Access application in a Remote Desktop environment, it comes out with an error message that says, Runtime error 2282 The...

Hi All! How can I email a report as a PDF format? I searched and found this but I get error message. DoCmd.SendObject acSendReport, [report name], acFormatPDF, "recipient's email", [title], [message], True This command is attached to a button. When I click the button, it runs this code but...

Hi All! Wish everyone well! I have a combo box named Session which comprises of am and pm. I have a number of fields that relate to this combo box. E.G. Monday am Sales £1000 Monday pm Sales £2000 I want to create a total Sales of the am and pm to derive a total of £3000.i.e. Monday...

dear all i have searched through the forum trying to get a solution as per above subject but to no avail eventhough I have gone through the 20 pagaes of threads. Maybe somenone can help me?? I have a summary form with the company name,week number, week-ending automatically populated. e.g...

Dear All I have been figuring a way to do this but it is not working... I have a combo box named session which drops down either AM or PM. I have an amount text box relating to the session. e.g. AM £1000 PM £2000 I also have a Total Sales Amount text box that we input the day's Sales...

When a query returns no records, the form appears blank. how can I make the form appear eventhough there are no records to show prior to inputting data. I have searched the forum but to no avail of what I need to do. Anyone please???

Dear All I need to pull the calculated values from approximately 10 forms into another form. This is a summary form that should have all the totals pulled from the other forms. e.g. Form A has a textbox that reflects the sum of the amount. This is the total balance of form A. Form B, Form C...

Hi All! I have a form with the following: A combo textbox with Category A and Category B. An Amount texbox. In the form footer, I have a textbox calculating the sum of the Amount. This works fine but how do I create a textbox that calculates just the Category A or Category B?? Anyone please...

I have a button using a macro to open a form in Hidden mode. Then I have another button on another form to open this form that was hidden. When I open the form, the form is virtually blank apart from the form caption name. But when I close this and press the button again the form opens as...

I managed to create a report by user using a combo box. When an user selects a name from the combo box, it generates a report showing all the records by that name. However, now I need to be able to generate a report as above but between 2 dates. How?? I am having two sets of criteria. 1) by user...

Hi All! I have setvalue to an item when the date is changed, an expression " You cannot change!" appears in another textbox. This is working fine. But i need the text in this expression to appear in RED! How can I do it? Help please! Thanks!

Is there a way you can auto expand a textbox in a form? E.G. you have 1 sentence in the textbox field, and this can stays as it is but when you have 5 sentences or more than the textbox automatically adjust itself to cater for the data. when i see the form with all these rows of fields, some may...

Hi all! I have a subform with a notes field. Upon creating a new note in the subform, I like to update a Date field in the main form to today. The date field consists of an old date which needs to be automatically updated upon creating the new note. How can one do this? Anyone help please??? Thanks!

Hi all! I am very puzzled over this. Maybe you good folks are able to enlighten me. I have created a report by assignee based on a query. When I run the query, everything's fine. The assignee name appeared. But when I generate the report using this query, the name field is blank!! Don't know...

Upon logging in, I need to set the username to a textbox in a form and store the field. I have a form named Task and it has a field named Username. This Username is the Masterfield in this form which has a subform. The main form and the subform are linked by the UserID. I am having a big...

Dear all! My advance search works perfectly with the ms access db residing in my local laptop. But once i install the file in the server, it does not work!!! I connect to the server via remote desktop. Once logged in, I open the Access db as usual. Everything else works fine but when I use the...

Hi all! Is it possible to automate the row height to increase depending on the data itself in datasheet view? EG. The data in one row is only 1 sentence so the row height is sufficient for that one sentence. Data in the next row may be 3 sentences so the row height must be automatically...