Search results

Is there a way to delay the creation of a form so that I can test if this is a data queue issue?

Is very strange. If i set the report to open in report view, it also doesnt show all the data. Is as if the report is made before the data is available, and then the data is available later and then whatever you change it to, you can see all the information.

Hello, I have a button which opens a report in print preview mode. When it is clicked, some of the text boxes are empty. If I then open the report in report view, or layout view, the data appears. Anyone know how to make it appear first time in print preview mode?

Thanks guys. It worked by removing clone. However, in the end i used an update query, which seems to be the better method, at least for me it was easier to implement.

Sorry to revive this dead thread, but Im trying to do something similar and having trouble. Dim rs As DAO.Recordset Set rs = Me.Transactions_subform.Form.RecordsetClone Do While Not rs.EOF [Status] = "closed" [Staff] = Parent.loggedinas [Payment Amount] = "10"...

Ok I solved my own problem. Its really weird, I have been looking at this issue for a few days, and its always just after I get really fed up and post it on here that I solve the problem. So what I did is create a query, use update query, and then get the ID from the form, and then update all...

Hello, So heres the problem. we have a form and a subform. Subform is in datasheet view. I want to be able to change a value on every record that appears in the datasheet filtered view. Eg. Im collecting all transactions for each individual. So I list the transactions by user ID. This is...

Thanks plog, after the usual fun and games of dlookup synax, I got it working. Just for others, you have to note that the dlookup of the average is not the same as the field in the design view. When you go to datasheet view, you will see that it has added AvgOf at the front, and that is what...

I want to display some average data on an input form. The average data is based on a query from the same table as the form. I can make the query, it generates the average, I can display this on my form, but now I can save the recordset, its giving the error the recordset is not updateable. Is...

thank you CJ. I will now being investigating LEFT Joins :)

Hello, Im trying to create a report, which will detail a history of a client. Some clients have purchasing history, some we just have their contact details. These are stored in separate tables. When I make a report that contains anything from a table that the client does not have an entry...

Minty, thanks. The first dlookup was working as it was. The second I re-wrote again as you did and it worked.

Firstly, thanks guys, I have been viewing this forum for months and its been invaluable for me. Now I have a problem which I have been stuck on for a few days. Heres the code : Dim framecost As Single Dim rightcost As Single Dim leftcost As Single framecost = 0 rightcost = 0 leftcost = 0...