Search results

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

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

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

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

Not sure what I am doing wrong with the statement below. It keeps giving me a debug error. I have this on a dropbox of a form. I want that when the user selects either of these that it will mark the fatal box as -1. What am I doing wrong? Thanks.... If Me.EventStatus =...

Not sure if this is possible but I have in my db a linked ODBC connection to a table. I use a Oracle 8 login to access the linked table. My question is can I capture the user login in ID somewhere in my table to show who is logged in? Thanks...

I have attached a really simple db where in a query I'm trying to determine the elapsed time between A sent date and a received date. Can some tell me what I'm doing wrong? Thanks..

Don't know if this is possible but I would like to count the number of cells in a spread sheet based on the text in the cell. I would like to count the number of fields with the word Monday in them. Is this possiible? Thanks...

I'm trying to limit the amount a user can enter into a employee discount field in a table. I would like to set up a validation rule in the table to limit the discount to no greater than $0.20 or 20 cents. Anyone have any recomendations? Thanks..