Search results

Too much questions at once. What mean "I have seen other databases that can somehow “pick up” files like this and update the forms status in the database (ie, Completed), assign a completion date and create a link to the file (a PDF actually)" ???? Have you a lot of pics (.tiff) and you like...

Not sure what you say. Should be a simple DCount function.

Not sure, but I think that the ShellExecute command will raise a error if the file don't exist. So use a Error Handler (OnError statement) in order to catch the error and to show the message.

... and use Option Explicit property for your code.

More: I suspect a wrong design of the DB.

Are you very sure that that column contain text ? I suspect that the column contain an ID (a key). Take a closer look at the subform's query (record source).

I think that is not possible, but I can see two workarounds: 1) Create a duplicate report, remove the footer and show THIS report if the number of users = 1; 2) Hide the controls in the footer if the number of users = 1. Me.ControlName.Visible = (NumberOfUsers > 1)

Sorry for you. Your DB is so simple... for sure me or other one can tweak the issue in minutes. Unfortunately I can't do this without to have your DB. So, if you agree, remove the confidential information from the DB and post it here. I use Access 2007 so, for me, you should convert your DB in...

Try this: Open the relationships window. Right click the arrow. Choose "Edit Relationship" Press "Join Type" button Select option 1 ("Only include rows....") OK. OK. Is now working as you expect ?

While the question is interesting, and I expect as well an answer, a quick solve is to instruct the users to use the old Copy-Paste feature.

Never never ever expose the tables to the users. The users should be able to see only FORMS. So, follow my previous advice: design a form based on the table.

Show us the tables structures and the relationships

:) Few more comas should solve the issue DoCmd.OpenForm "FrmBankDetails", , , , , , Me.StudentName

You "feel" that you need 2 different information but now you wish to, somehow, concatenate this. May I ask WHY ? My advice is to keep the actual structure of the table. If you haven't an ID field add it (autonumber) Design a form based on this table and, if you like, make invisible anyone of the...

Fully agree !!!

Still out of border of my understanding. I understand very well your English (and I'm proud :) ). But still I don't understand what you are looking for. I'd asked you to explain the problem in human words. Instead you show me a procedure in VBA language. You ask me what I think. I think...

Welcome to AWF ! Hope I understand well your problem: You have a form where you display all the records. Now you like to have some combos from where to select certain properties and the data in the form to be filtered according with the selection(s). Is that the problem you are facing with ?

Welcome to AWF ! I'm sorry to say but the project seems to be a little bit more ambitious for your knowledge. First of all you must UNDERSTAND this: Database Normalization and Table Structures - Microsoft Access / VBA Then design the tables according with this. Come back to us whenever you have...

Try this: Open the Sheet (in Excel) Navigate to "Developer" menu. Under "Controls" tab click properties. The "Properties" window should open. In the "Properties" window, the very first row is "(Name)". As I write, with rounded brackets. Try to use THIS name instead the sheet name that you see in...

The red part break the main rule of databases: Do not store what you can calculate. Database Normalization and Table Structures - Microsoft Access / VBA I know: this is the approach for Excel, but, in Access, you should create a report where to display the concatenated values from your fields.