Search results

I have a command button that opens a report with a where filter. The report has a main section and a detail section. Its a Organisation and its Contacts. The Contacts are in the detail section. How can I suppress the detail section (and a label) if there is no records to show in the detail section?

I have my Contacts form open. My Company form is also open, with a subform having contact data. I add a record to my subform. But, if I then go to my Contacts form, I see the record is not in my Contacts form unless I reopen that form. Do I need to do a requery or something? I ask because I...

I have Contacts that can be linked to many Organisations. Each Organisation can have many Contacts. So, does that mean I need a Many to Many relationship with an intermediate table? Contacts - ContactsOrg - Org Also, for each Organisation, I need to have a memo field, so that specific...

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...

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...

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

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

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 have a query where one of the fields is: Inv: Inv1 & "/" & Inv2 & "/" & Inv3 This works fine and displays 3 numbers like this: 234/215/235 However, the Inv1, Inv2 and Inv3 fields are actually comboboxes which store the ID field of the lookup table. So, instead I want to do show this...

I'm creating a report that will show Jan-Dec in the first column. The next column shows total record counts for each month. Next, I want to show the record counts for each month but filtered by location. i.e. first column is just the total, but second column is a filtered total. Can I do that...

When I clicked Create blank Form or try to just go to design view in my unbound form, it takes forever to load, maybe 20-30 seconds. Why? The front end is on my desktop, with the backend on the server, which is about 90MB in size. I am using Access 2007. Is it anything to do with it trying to...

I have a field in the header called SearchByJobNo. I want to click in there type in the Job No and it will search on the Job No field when I hit enter. Unfortunately, the Job No field is not unique. So when you hit it again, it should then go to the next record with the same Job No. Any easy...

I have tblClients and tblOrders, with a Main and Subform accordingly. I would like to click a button when on a particular client record and then this will create a list of items ordered with the order status set to Not Sent and put them into a memo field on the main form. Output to memo field...

I have Access 2007 in a multi-user environment and we need to lock the edited records. The database is split into a front end and back end. Do we apply the record locking settings to the front end or back end? Thanks, Dave

I have a subform in Access 2007, which was created using a wizard. When I click any of the fields, it highlights a rectangle that is larger than the field itself and encompasses the label above it in the Form header. It is like a dotted line around it. What is this? How do I add/remove this...

I am having trouble to get to grips with the Access 2007 Form. In earlier versions, I could rapidly create attractive looking Forms, but the 2007 version seems to have a mind of its own! I have a Form in what I think is design view, although the top left toggle button shows View. When I try to...