Search results

thank you

Thank you for the reply. I was trying to put a single link to my website. When I'm answering someone else's post (as I've already done on this site without a link)

That's how I started this post: explaining that I'm happy to answer others' questions (25 year veteran). And I'm wondering why you have a hyperlink for me to place a link (ex: to my website), but when I use that hyperlink, my reply is blocked.

I tried to post a website to datacontrolllc dot com to answer your question.

OK. I guess that was a poor assumption on my part. Instead of trying to hide display the page footer based on the number of pages, use the report footer instead. the report footer displays on the last page of the report (which meets your criterion) Jack Owner Data Control, LLC

Have you attempted placing in the footer what you want, and then using the page footer's on format event to hide/display the content appropriately? Jack Owner Microsoft Access Programmer

my actual reply is much more informative. but I can't seem to post it.

I'm attempting to answer your post. every time I get an 'Oops' message

Actually, a database like this would typically keep the lookup tables in order to populate the combo boxes with a unique list of values, thus restricting data entry to the list (data validation). But maybe for your purposes this isn't necessary. Jack

UncleGizmo's comment: "Instead of having the lookups as queries you could just have a combobox on your form" means in the query above, you don't need either the outer join to 'qrylkpStaffName' nor join to 'lkptblStaffyType. Both of these complicate your form unnecessarily and could cause...

I think you are seeing a lot of google posts for both multi select list boxes and then multi column list boxes. For a simple list box, me.lstName works just fine. So you code would be txtTextbox = lstListbox, basically. you could improve clarity with me.txtTextbox = me.lstListbox. And if you...

So your question is how to create tables with the fields you list above? or is it how to create the database in general? To create a table, open access and start creating a table. Add the field names and choose the data types. close and save the table with the desired name. To go back and...

I see you've gotten enough suggestions on VBA automation of Excel to keep you going. But might I suggest another, much simpler approach? Create an Excel Template file. Start your code by copy/pasting your excel template. For example: filecopy "c:\exceltemplate.xlsx", c:\exceltemplate - " &...

Thank you. Do you support dofollow and nofollow links? I'm happy to answer lots of Access questions for folks. But I'd also like to get some traffic to my site. All the best to your forum and I look forward to posting here often.

I've been programming in Access for 25 years. Here's wishing you all a Happy New Year! Jack Owner