Search results

I have an odd situation. I am trying to program a combo box to select two different sets of criteria depending on the value in a text box on the form. For example, when I open up the form, it is pulling in a Manufacturer name from another form based on the Equipment ID. But if the equipment...

When I delete a record on a form, I want the form to go to the previous record. This is no problem except when the record I want to delete is the first record. How do I check for that?

I am looking into getting certified in SQL Server. Anyone have any good advice on where to start, what kind of books or training to acquire, etc?

I know this should be easy, but how do I hide a field if there is no data in that field? I have a field called "other" in my report that I do not want to show if there is nothing in the field. Thanks for your help.

I am needing to attach pdf documents to records in my database. I have looked into the Attachment function of 2007 database, but it actually stores the records in the database, thus enlarging the database. Surely there is a way to have a link to any pdf documents I want to attach to a...

I have a database that has an equipment table. Several of the pieces of equipment are the same, i.e. hospital beds. The question from one of my users is.... is there a way to add a comment to several pieces of equipment at the same time. For instance, I would need to search for hospital bed...

I have several enhanced listboxes in a form, but they are not saving the data selected to my table. Any ideas why?

Does anyone know of or how to create a menu program for databases. I used to have a little visual basic program that would list all my databases and I could just click on it to open it. It doesn't work with 2007 databases, however, so I apparently got rid of it. Any ideas on this?

I have a database that sends emails to a certain maintenance worker depending on which nursing unit the request comes from. The program we use is a little free dos-based email program. We use Groupwise as our email system, not Outlook. Does anyone know of any other reliable email programs as...

I have some users who have the runtime version of Access 2007. They are needing to export some reports to Word, but I cannot seem to find how to do this. Am I just overlooking the obvious?

Is there a way to email a report from Access 2007 runtime?

I have a form with selection to create a report. Everything works fine except the sorting part. I have a series of 8 combo boxes to choose the sorting order of the report. The users will probably never use all eight, but I gave them the option. Anyway, as you open the first box and choose a...

I have a huge table that I am trying to query for a date range. Is it faster to do a select on just the fields I need as opposed to a SELECT * FROM (tblname)?

How can I program to use the Cancel on the InputBox? I have a form that has a copy button on it. When I copy the record, it prompts for a new Equipment number. If the number exists, a msgbox pops up telling the user to enter another equip number. It then goes back to the InputBox to enter an...

Is anyone else having a problem creating charts in Access 2007? I don't know if it is some kind of bug or what, but every time I try to create a chart based on a query, I either get an error that kicks me out of the database, or it won't close and save. Is this a known problem?

Is there a way to put a record back into a table with the same autonumber it used to have? For instance, I accidentally deleted record # 8 and I need to reinsert it with the same number, which happens to be the Work Order ID field. Is that possible?

Is there an easy way to put some descriptive text inside a textbox, have it grayed out, and when you enter text in the box, it overwrites this text? For instance, I have an Issues database. In the text field, I want to put the text as follows: Enter your issue here. Then when they type in...

I am trying to copy a record on a form, but when I do I need to put in a new equipment id number. I have some code to check for duplication, but it does not appear to be working quite correctly. Can anyone see anything obvious? I know this should be an easy solution. Thanks. newID =...

Can you do a Do While IsNull([table]![field])? Is there a way to make something like that work? I have a form that creates new work orders, but it doesn't populate the work order number field. I would like to loop through the table and insert a work order number if the field is null. Is this...

I have an Equipment form that is used to list pieces of equipment. Sometimes these pieces are very similar and instead of re-entering all the information for a new piece of equipment, we just want to copy the record. I have a copy button on the form with some code that performs this task...