Search results

If you're reasonably au fait with Excel and have made a good standing start in Access, I'd recommend the Microsoft Press Step by Step series. I have both, but prefer this one, and it leans towards their MOUS qualification for Access too, if you're that way inclined.

That's exactly what I meant.

I've created and tested a (simple) database tool that allows staff to amend a couple of Oracle tables but keep backups, change history and blame trail. This is my first Access project, having gone straight from MS Query to MS SQL Server - I'm know learning how powerful Access can be and how...

Most helpful - thank you again

It's for a team of four, very untechnical, people. The database will be restricted to one of them using it at a time. I'll try the help in the Expression Builder - I just got a little disheartened when the main Access help didn't recognise DMax()!

Sorted - Thanks =DMax("FIELD","TABLE")+1 worked a treat, once I'd got the syntax correct. The Expression Builder isn't a lot of cop for this is it? Better to use the Internet!

I'll explore DMax(), for which thanks. I'd rather not let them have access to the main table until I've got some kind of backup to undo their mistakes!

I have a table, which is a local copy of a linked Oracle table, where one of the fields is a unique record number. I've built a form which enables people to edit the local table, changes being posted to the linked table on closing the database. I'm having difficulty building an expression in...

Don't you just love Access! I've solved my own problem! The correct syntax was Trim (Str ([LOCAL_WWUAPINVAPPR].[PROXY])) = [Forms]![Frm Inv Appr Picker]![PickProxy] because Access was adding a leading space to the string when converting from a number! :mad:

I have a form where users enter search criteria. On clicking a button, the subform should display the data from a table that satisifes the query. What I find is that the search box that contains data that will be found in a text field works. The two search boxes that contain data that will be...

You may be onto something there - replacing the Form references with static values in the Query appears to have made no difference to the functionality of the Form! Back to the drawing board :o

Yes. The Where clause refers to a leaving date field in a linked Oracle table which can be either null (which shows as 01/01/1700 but don't ask me why) or a proper date. By using Now() and Null, I'm only grabbing those employees that have not yet left. These combo boxes populate okay but the...

For the one that works: SELECT distinct [LOCAL_WWUAPINVAPPR].[ACCT_UNIT] FROM [LOCAL_WWUAPINVAPPR] 1 1 2.011cm For those that don't: SELECT distinct [ULTMAST_WWEMPLOYEE].[W16_EMPLOYEE] FROM [ULTMAST_WWEMPLOYEE] WHERE [ULTMAST_WWEMPLOYEE].[W16_TERM_DATE]=#01/01/1700# Or...

Apologies if this has already been answered but I couldn't find a previous thread that answered it in the first fifteen pages returned by my search :o I have a form with some combo boxes, populated by queries from larger tables, and a subform linked to a query which is supposed to return the...

That worked perfectly, thank you. I hadn't previously known of DLookup but I understand the syntax of it and it does the job very simply. Thanks again :)

Similar problem I'm encountering a similar problem to this one but the posted reply doesn't do it for me. I've created a form which shows the Network Username and Computer Name using Environ variables into Unbound TextBoxes and these work fine. Using the Network Username, I'd like to display...