Recent content by gbanks

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...