Search results

I am looking for a simple code snippet for how to create a Query in VBA for Access 2010. I've done it for early versions of Access with DAO etc, although I haven't done this in ages! So, any good examples of a simple query? I can then modify the code to do what it needs to do! Thanks, Dave

I have a value in an unbound field on a Form, which is 1234 OR 765 OR 356. In the QBE criteria grid, I used builder to reference this form: Forms!myform!myunboundfield The column this is in is for the ID field, which is a number. However, it is not filtering the data correctly. If I copy the...

Actually, the Calculated field is unbound and on the Main Form. It is a total of values in the sub form datasheet. However, when I update a value in the datasheet, I want the dsum value on the main form to update too. That is why I have used a requery. Perhaps there is a better way of doing this?

I have a main form (tsTimeSheetMain) which contains a sub form (tsTimeSheetDataNewSub) in data sheet view. When I click off one row onto another row in the sub form, it triggers this code: Forms!tsTimeSheetMain!ProjectMonSum.Requery i.e. it tries to requery the ProjectMonSum field (on the main...

My report shows one record. I have a border around my textbox and its label - in fact 30 rows of them. I used Arrange and Stacked option. This all looks fine. However, I now want to add a third column, the same width as the second column. So I copied and pasted the textboxes and labels, and had...

You were right Pat. I stopped using calibra in the report and it worked.

I found out the problem. The calculated field was called Bar Deposit Comments which messed with it! Doh!

I have this formula for my calculated field: =[Bar Deposit Comments] & " Bar Deposit: " & CStr([Bar Deposit (incl VAT)]) For some reason, it is showing an error in the memo field. Is it a problem because its a memo field or have I missed something here? Thanks, Dave

That was really useful. Thanks. :)

Ahhh thats a good idea! Thanks Rain.

I can use that in the QBE grid? I need the filter for the query and not a vba created query.

I can check using Is Null as a filter but what about if someone has previously entered a date but then deleted it? It won't be a null. So, what criteria would I use to check for that in my query? Thanks, Dave

I have a time field MyTime where I want to add 45 minutes. I want to then store the result in a memo field. I've tried this: MyMemoField=[MyTime]+45 It doesn't work!! Any ideas? Thanks, Dave

Interesting point! That seems to do the job. Thank you. :)

I have a Form with a field called LastUpdate. I want to track whenever the record was edited and put the current date/time in the LastUpdate field. Do I just use the Forms AfterUpdate event and use now() or today()? Thanks, Dave

In a memo field, I have some text and a value such as £5.23. When I create a report to show this memo field, the £ changes to a J. Why is that? Thanks, Dave

I'm pleased to say your solution worked Beetle, thank you. :)

The difficulty I have is that the client already has a complex database with many things bolted on a bit like a Frankensteins monster. So I am trying to find a bolt on solution. Is it possible for me to use a Dlookup function as part of the query column formula? i.e. Dlookup the value in the...

Its not quite that simple! There are 4 fields within tblInvoices that lookup values in the Lookup table tblEvents. Lets call them say Event1, Event2, Event3 and Event4. Each of these fields looks up an ID within tblEvents. I want to use the EventName field but can only get the EventID. Does...

Unfortunately, I can't change the tables because they are linked in to so many things, so I have to work with what I have got. There are no related Forms open when I launch the query. I can bring in the lookup table into the query and set the join correctly. But if I have that lookup table in...