Search results

hello, I have created a form that uses a subform to display the results of a query. the subform query shows the entrants name and a flag, i would like to populate certain cells in excel with the fields of the record that has a checked flag. Is this possible? Many Thanks

hello, I am trying to create a form that uses a subform to display the reults of a query, my problem is that i have 5 queries for the user to choose from. Is there any way that i can use the one form and populate the subform with the users chosen query or do i need to create a form for each...

Hello, I am trying to create a form that loads up text boxes with a number taken from a query. the code i am using is Dim stDocName As String stDocName = "Total Pages by Printer" DoCmd.OpenQuery stDocName, acNormal, acEdit Which opens my query. I then have to enter a date is...

Hello, Is there any way that i can code a macro or module in access to run an excel macro that formats data and saves it as an htm file and then import the htm file into access? Thanks in advance

Hello, I am trying to create a label on my database menu that shows when the data was last updated. I am trying to read the date from Print end time in the table Print Data. The data is sorted ascending using the Print end time field. I have tried a query to show the last record however...

I am running delete and append queries but when i run them i'm asked to click yes, no or cancel, is there anyway i can bypass this and have automatically select yes? The code i am using is Dim stDocName As String stDocName = "AppendDups" DoCmd.OpenQuery stDocName, acNormal, acEdit...

Hello, I have a form that performs a calculation, i am trying to add the data in the text boxes into a table. I have managed to get the data into the table however one of the text boxes contains a percentage and once entered in the table rounds up to the nearest whole number, i have tried to...

Can anyone help me, I am trying to create a form with 2 text boxes on, i want to enter an id into the first text box, click a button and have a different field from the record appear in the second text box. Any help would be much appreciated. Many Thanks

Hi, I am trying to calculate the total number of mail pieces between two records. The number of records may vary between the two ID's. I am trying to create a query that when run will ask me to type in a starting ID number then ask me to enter an End ID number then want it to show me the...