Search results

Hi - I have searched this board and cannot find anything that has worked. I'm hoping someone can help and maybe I've just missed it somewhere on this board. Here's the thing: I worked for 3 months on a MDB and got it working the way I needed. I then ran it for the date range I needed and...

Hello - Here's my problem: I've created a mdb that i'm trying to run from a command window. When I type "vemacro.mdb" at the command prompt the mdb runs fine. But - after it runs I get a popup error window that says "cannot find the file "f:\ve\vemacro.mdb" (or one of its compenents)." But -...

Hi Rich, Thanks for the code. That should work perfectly. Caitlin

Hi Rich, thanks for the reply. I have that part working. I just want to be able to put the search criteria that the user enters on the report. But - I only want to show the criteria that they entered. In other words if they enter name but leave DOB blank - then I want the report to say...

I have searched the posts on this site and cannot find anything that fully answers my quesiton/solves my problem. I have a form that has all unbound text boxes on it. It has 12 different boxes. I then have a report that is based on a query. The query filters the data based on the info that is...

It's a text field - 1 character in length.

Hi Wayne - thanks for the post. I tried changing the code as you suggested (grade is a text field) but it still pulls ALL records. Any other ideas?

Hi - I know there are lots of posts about this but I can't get anything to work. I know I must be missing something. Here's the scenario: I have a form that has button to call a report that is based on a table. The table that the report is based on has a field called "grade". When this...

Hi - I tried that but I keep getting an error on the line: me.period_combo = inputbux("Enter the period") I had that line in the "on open" trigger in the FORM property.

Hello - I have searched this forum looking for an answer to my question and cannot find anything that works. I have a form with a subform on it. The subform has a combo box that allows the user to select a "period" (PK, K, 1-4). This is saved in a field in my table called "period". When the...

Hello - I have searched everywhere for information on this and can't find anything. Maybe it's just not possible??? I have a table with some basic fields in it - ie. name, address, city, state, etc. I also have pdf (in the same directory) that I want to be able to pass these fields to the...

Ok - I put the new syntax for DMax in my form and now I get a different error. I'm researching the error but not finding anything on it. Here's the error message: "The object doesn't contain the Automation object 'tblEvidence_location.' You tried to run a VB procedure to set a property or...

Hello - I have searched this website for an answer to my question and I can't find anything that will work the way I need it to work. I have a main form with a button on it called "add record". When the user clicks the button another form is called where the user can add records. This form...

I found a way to do it. It was very easy..sorry to have bothered you all on this site. For anyone who can't find it - you just embed an object in the form. works quite well. tks caitlin

Hello - I'm not sure where to start to accomplish what I'd like to have. I have a form built in Access. The user has some word documents that they want to be able to view from within Access. I know how to set it up so that they can click on a button and it will open Word and show the...

Thanks for the help. I did try what you suggested and now the name lookup doesn't work. I can't enter part of a name and have it pull up all corresponding records. However, the account# and policy# lookup now works. Any other suggestions on how I can get all these of these to work at the...

Hello - I have the following problem that I'm hoping someone can help me with. I have a form that has 3 list boxes as search fields. They are account #, policy # and name. When one of the search fields is filled in and <enter> is pressed it populates the subform below which shows the...

Thank you. I'll try both of your suggestions and see which one I can get to work. Caitlin

Hello everyone, I have a question that seems like it should be fairly easy. First some background info: 1. I'm modifying an mdb that was written by a different programmer. 2. I"m using Access '97 I have a form that has 3 list boxes - policy #, Acct # and name. It has a subform under it...