Search results

Got it. You idea put me on the right path. I broke it down in a macro and I found that someone modified the export query with a field that was not in the export spec and it caused it to fail. Thanks so much!!!

Using the code below to export a file to a location but for some reason I keep getting an error "runtime error 3011" "The microsoft jet engine database could not find the oblect." "Make sure the object exisits and that you spell it's name and path namecorrectly" . I made sure a named file was in...

I have a date field in my query for which I only want to pull the last 6 months of data from the current date. How can I do this? Thanks!

Using the code below to send an email from my db. Works great except my users would like the stBody string to be the text in a word document they update periodically on a local shared drive (drive =F). Is there a way to make the text from there word doc the string I'm looking for? Thanks.. Dim...

I have a subform I am using on a form. I would like to modify the code below that I have for a button on the form. I would like to use the master and child field link in the code below to only show candidates related to the main form. The link is candidate id. I have this working with a subform...

In the attached db I have a form I use in datasheet view to show data. I have an attached subform that the user updates. The user opens the subform by clicking on the + sign to open the subform, the updates the fields clicks the + sign again to close the form. Then repeats for the next record...

I use the code below on a search form to filter my table for data. The code works pretty well but it has one bug. The text box on my form that captures when the event occurred has 3 types Pre-Admin, Admin and Post-Admin. The problem is whe the user selects one of these types from the dropdown on...

I've been asked to make a survey db by someone. I was wondering what is the best way to go about this? The output spread sheet list several questions asked of the user. The user id and questions asked are in columns. So you could have a columns like the user id: date: when was the last time...

Attached is a really rough db. I used this just as an example. I have a close button on the subform pndata_frm. I have the button so it closes the record and then moves to the next record. The code used for this works ok if the user closes say record 1 then record 2 in order. But if they skip...

Thanks Thanks John That was it..

I use the code below on a search form. I would like for the results of the list box search to populate a report instead of the list box. Is it possible to take the the sql and move it to a report? Thanks.. Dim strsql As String, strOrder As String, strWhere As String Dim dbNm As Database Dim...

Using this code as part of a module to open a report in print preview and set it's recordsource to the sql I have written earlier in the code. The problem is when I run this it only prints the report it won't show it to me in print preview like I want. Anybody know what's wrong? Thanks...

Here's a simple example db.

I know that's where I'm having a problem. It keeps telling me to select a different table/query. Can I do this manually without the wizard? Thanks..

I have a db which has a field called site_id it a table called sites. I have a form called sites which uses this table as a record source. I would like to make a combo box on the form as a drop down whenever the user selects a new site id it will take them to that ID on my form. I saw where...

Thank you SOOOOOOOOOOOOOOO MUCH!!!! I got it working just the way I needed it to. Awesome!!!!

Ok this null value thing is killing me. I have a parameter query that works great. I know if I use Is Null in the criteria field it will show me this. The problem is I made a search form which the users type the value in and it opens a form based on the parameter query, the parameter on the...

Using code on a form to look for a null value for a field on my form. For soem reason this isn't working. I'm checking for a null value in the field on the form. Even if the ClosedDate field is null it still shows the Not null message box. Am I doing something wrong? Thanks Private Sub...

I made on option box on a form called Status. The 2 radio buttons are marked Open = 1 and Closed = 2. Is it possible to open a query based on what the user selects. In the query I want open to stand for Is Null and closed would be Is Not Null. I know this sounds unusual but it works in the...

I have a form (form1) with a subform (form2) on it. I would like to be able to filter the records that show on form1 and form2 based on a field on form2. I would like only the record to show where the field date on form2 is null. Is this possible? Thanks..