Search results

Having given it a little more thought, could you reconsider the database subject? The problem is, unless you put in a lot of work, your hotel database isn't going to be that great and will appear flawed. It's potentially quite a big project. I'd suggest going for a simpler subject on this...

A hotel database should be complex enough to be good and not "simple" unfortunately. You'll need quite a few tables here to get things working well. You'll need a customer table. Include; CustomerID (Primary Key, Autonumber) FirstName LastName Title Add1 Add2 Add3 Postcode/Zipcode County...

I was just about to edit my post! :banghead: I've only linked a spreadsheet and an outlook table and on both occasions, read only.

I've just linked my outlook inbox and it contains a "From" field but no email address field. The idea is that I would like to include a continuous form of recent emails from a contact in access. The only way I can filter the linked table is with the email address but it's missing. Does anyone...

So far as I can tell, linked tables are read only. EDIT - The above is all lies.

Thanks again, not the suggestion I was hoping for but has made me identify a workaround. Switching the RecordSource to copy of the original query with the critieria removed, just the opposite of your dummy query and returns all records. Cheers :)

Hi Pat, Thank you, much appreciated. I've ditched the temp var and added the arguments to the SQL, it works and will be used a lot. On load the query returns all records as intended. The only problem is I'm having difficulty restoring the field to a null value that the query recognises as...

Nothing quite like digging up a decade old thread but hey. I'm getting a bit stuck with this. I have TempVars in my query criteria, however, no matter what I put in the temp var I can't get the query to return all records. IE I want the option to view all and filtered. I can't use ApplyFilter...

Can you upload a screenshot?

Cheers, it's selective extraction unfortunately. A quick look at char maps and I think I should replace 13 with 32 so to give a space and not join words. I THINK! Access and VBA are still pretty murky to me!

Hey there, I use this tool online a lot as part of my work; http://www.textfixer.com/tools/remove-line-breaks.php It would be good to add this functionality to my database for speedier input from PDFs and so my users don't have to navigate online. Any suggestions on how this can be achieved?

Thanks again, I've tried getting that code addition to work but no luck. I'll figure it out though :) Think I'll upload the working chat db soon, after a few tweaks as it might be useful to other beginners like myself.

Applied the code and it works great. I added a couple of lines "Recordset.MovePrevious" so more of the thread is shown. This causes an error on new threads but not a problem for my main project as the new comments will be delivered to the top, makes things easier. Not to the norm but fit for...

That's brilliant, thank you, much appreciated :-)

EDIT again. Thinking about it some more. This does sound like you're asking the implausible from 1 combo.

I must have refreshed this page a hundred times today. I would really appreciate help on the above. Thank you :)

I've tried loads of things now, nothing works, very frustrating. I've attached an example of what I want to achieve in my main project. It would be interesting to see how different people achieve the same result and also REALLY useful and much appreciated. I've removed my attempts at VBA for...

Thank you! I'm getting the error message as attached. I haven't yet learnt enough to know what this means. Any help much appreciated!

I have looked for hours trying to find a working solution for something that seems so simple. I have a form called Enquiries In the Enquiries form is a subform called enquiry notes I have added an unbound textbox so users can add notes to enquiries Notes are stored in a table called...

Hi there, I'm in the process of making a database to handle ad campaigns. I have a creatives table logging the creatives; Fields; Size Format Theme Colour Wording I have a campaigns table logging the campaigns; Fields CreativeID Network Country Status The client provides me with a landing...