Search results

For your second half of the problem, you might want to explore using a List Box. It can be set up to select multiple entries in a list.

LOL! I appreciate that! I can totally understands both sides of the coin (having been on both sides ;) ). It is -oh so frustrating- so see projects ( I am not involved with) sputter along due to poor or mis-communication.

While I was getting my Electical Engineering degree, I discovered I had a knack for programming. After school, for reasons I won't get into, I have never had a position as any kind of engineer. Mostly business analysts type / data crunching positions. I was better than my co-workers at data...

Can you change [Cmb_Month] to store the numeric equivlient of the months? ie [Cmb_Month] = 1 instead of January? If so, then you could use a function like DATEVALUE to help indentify your start date.

The concept still applies. Just instead of the previous combobox, you need to select from the specified column (filtered). If this is incorrect, please restate your original problem as I am not following otherwise.

For the combo box issue, trying searching the term "cascading comboboxes".

References are set for each database, not for the computer. I have a number of database that may have the Outlook reference set, but if I am in a database that doesn't have that set, I would get the same error if I tried to reference an Outlook object.

Maybe the Outlook reference library not set on computers running your database?

Just throwing this out there: If the value of Me.Fehlteil.Value is null, then the true portion of the if statement will not execute. Is this what you are seeing? If so, change the if statement to If Nz(Me.Fehlteil.Value,"") = "" Then

Take a look at a few of the examples here: http://btabdevelopment.com/code-snippets/page/2/ Exports your data and reformats.

Yes. In the On_Change event for the combo box, you can use Dlookup code to assign values to your textboxes.

I am making a guess here, do you want your textbox hidden from view, that is why you are putting it behind the button?

I had a very similiar requirement. If I remember right, the query below worked, but it was very slow. SELECT query.Filename ,query.rowcount ,query.exception ,query.runDate ,Master.sortorder WHERE query.filename LIKE Master.Filename* The LIKE statment isn't exactly right, but maybe you will...

In Tools Reference, look for the file named "Microsoft Outlook XX.X Object Library". That should get you past your current issue.

Argh! Frothingslosh beat me to it! :D

Change the rowsource of the dropdown box to a query based on the reason table. For the Inactive field, just set the criteria as "No" (or False or 0). This will return only the reasons you have flagged as active.

Yes, research "FileCopy" on this site or on Google. That should enough to get you going.

The potential for conflict does exist, but to reduce the risk, create the record immediately after getting the next VisitID. The risk increases if you ask for the next VisitID and do other operations before creating the record. That gives the next user to ask (and receive) the same VisitID.

I think that maybe MarkK misunderstood the question. His provided code would give the numbers of days that have passed since 1/1/2014. To attack your counter problem, I would use a DMax function on the VisitID field for all records with today's date. Your code might look like: lngNewVisitID...

Also, Access is limited to 2GB per file. After that, you are begging for problems. Simply put, file "bloating" is due to actions that could increase objects (tables, forms records, etc) followed by actions that reduce objects (deleting records, tables, forms). In some cases, you won't be...