Recent content by Not A PHB

Are you using Security? You could set up users with read only permissions for that table by using the Access security wizard on your backend database. It's quick and easy but there are some gotchas to setting it up if you haven't done it before so I'd back up your databases first : ) Just a...

Thanks for the quick reply! That does get me closer to what I was looking for and I'm going to use it if I can't get my linked object to update which it looks like I can't :confused: I think what I'm going to do is use your code for the preview and add a double click event that will open word...

Me too! I would love an answer to this problem. I can't figure it out. Thanks Lance

I don't think there is a way to use an input mask on an input box but what you can do is create your own form and use it in place of the input box with very little change to your code and the addition of the new form. I've attached the sample database using your existing code, command button...

Sure just select Properies/Data/Input Mask and Password is one of the predefined Masks. Works like a charm and you don't need to bind it to a table. HTH, Lance

I like the way you put that :p Just like the hot chicas I want it mostly for the wow factor. Lance

Cool!! Thanks Paddy!! That is a keeper! :)

Images in a dropdown While you can't place them in the drop down you could reference them and display them on your form when you select them from the drop down. Here is a simple example. Maybe it'll help. Lance

Where's my attachment? Try this again I forgot to zip it first.

If you place the mask in the table it should work. Or you can do this before inserting the data in your table. Right("00000000" & ([user_ID]),8) You concatenate 8 zeros with your user inputted number which would give you 00000000123 for example then you specify how many characters from the...

Input Mask All you need to do is go to the Properties/Data tab of your form and copy this into the input mask line: 00000000;; or you can do the same thing in the field within the table if this is a bound textbox. You can create and save your own input masks by clicking the elipses (...) at...

Progress Software My wife works for the company as a Tech Writer. They are a player in the embedded database market so not many people know the name. It's a global company and has been around for more than 20 years. I've never used the product but if you contact them they can tell you alot...

I believe the contents will be overwritten with each import unless you link the spreadsheet and append the data through a query. If you would like the data overwritten each time you can delete the contents with a delete query and then append the new data from the spreadsheet all this can be...

Have you tried compacting and repairing the database? Sometimes that helps when nothing else seems too. I haven't seen that specific error before so I'm afraid I wont be much more help. Thanks, Lance

Hi Sara, By duplicate results do you mean the entire record is duplicated or the position is duplicated for each applicant that applied? If the entire record is duplicated a group by statement should take care of it. SELECT qryApplication.AnnouncementNo, [qryApplicant].[LastName] & ", " &...