Search results

I have a simple database consisting of a table of driving school pupil details and a linked table of the lessons they take including how many hours for each lesson. I've created a form with a subform. Parent record details on the main form and a table of the lessons on the subform. When I...

I have an application that looks up an address and then takes the address found and puts it in to a string field in the main table. Not quite sure what's been happening (user error the most likely) but sometimes I'm finding a CR/LF at the beginning of the field (in the database, not the lookup...

OK, thanks. I'll have a play with that way of doing it although it's all working OK now with the datevalue() option. Cheers David

Yes, I did look at doing that but there are lots of reports we produce for the end clients and because of the nature of the service we provide, the reports run from a date/time to another date/time for example, at a weekend the reports would run from 5pm Friday to 9am Monday. Thanks again for...

Hi both. GlaxiomAtHome - Thanks for your help. I did start having a play with your solution but was having difficulty getting the syntax right. Your example is shown as the Where clause in a query. Should it work as part of a filter on a form? vbaInet - Thanks, DateValue() works a treat...

Hi. Here's the database. The form is the only one there. Just realised that the code you supplied me is in there but I have edited the line for the date filter and made it a 'between' rather than equal to. But that's only becuase ito didn't work the first way. Cheers David

OK thanks. I'll get a copy of the live database and strip out all that's not relevant. Cheers David

Ah yes, I can see the edit button now, thanks. Yes, I did try your code and I get the same result. Filtering by Customer or Job Type works fine but not that date. The original code with strFilter "1=1" was given to me by stopher. Cheers David

Hi vbaInet, Thanks for getting back to me. I tried to edit the original message and couldn't see how. Anyway, the strFilter = "1=1" was suggested by another contributor to guard against nulls or empty strings being passed to the filter i.e. strfilter will always have a value in it...

Hi, I've reposted this as I originally didn't enclose the code properly within code tags. I’m having a problem with some form filters that were working OK. I’m loading a multi-record form based on a query: Q_UpdateRecords SELECT T_CallDetails.[Reference Number], T_CallDetails.custkey...

Sorry about the missing code tags. It's the first time I've posted any code like this. I've tried to go back in and edit the message to put the code tags in but that results in loads of font tags appearing - looks a little like HTML. Should I delete and start again? Cheers David

Hi, I’m having a problem with some form filters that were working OK. I’m loading a multi-record form based on a query: Q_UpdateRecords SELECT T_CallDetails.[Reference Number], T_CallDetails.custkey, T_CallDetails.CallDate, T_CallDetails.Name, T_CallDetails.Address, T_CallDetails.[Call In...

That's brilliant, thanks David. I was looking at the Spelling autocorrect options. Found it now, thanks. Cheers David

Hi David, I'm developing in Access 2007 although the database runs under 2003. How will the auto-correct help? I can do a find and replace OK in the code modules but it's anywhere that the field is used in a form or a report or a query that concerns me. Cheers David

Hi All, I've taken over a database where the original developer created a field called Date in the main table. I'm having all sorts of problems in code where I try to do things with date as it's a reserved word. So I would really like to rename it to something like CallDate. Is there a quick...

Thanks Mark. Yes, that's fixed it. I'm doing all the development work in Access 2007 but the application will actually run under 2003. Will that be an issue with the reference? All working perfectly now thanks. Cheers David

Hi Mark, Fell at the first hurdle :( The line Dim rst as dao.Recordset returns a Compile Error: User-defined type not defined Any ideas? Cheers David

Mark, thanks for that, really appreciate it. I'd pretty much got that except for the DLookup. That's a neat alternative to SQL. Cheers David

Hi Mark, Thanks for the quick response and for the help. I'm in my 50s and haven't done any real coding for about 20 years - and that was good old character based apps and procedural languages. Your code for working through the table is nothing like I was expecting and I hadn't come across...

Hi Mr B and Lagbolt, Thanks for responding so quickly. Yes, I understand exactly where you're both coming from regarding normalisation. And I normally wouldn't design a database that looks like this. So a bit of additional background will help. This data actually comes in to us on a...