Search results for query: *

I have a sql command I'm trying to execute and can't get the syntax correct. I have a temporary variable that is storing a text date (format '04/2012') and would like that converted to a date when it appends. What I have is as follows: DoCmd.RunSQL "INSERT INTO Currentsalary ( [Personnel...

I am appending data from a temporary table which was imported from excel so all the fields came in as text although things like salary need to be a number. My solution for this was to append into my permanent table (CurrentSalary) the val(annual Salary) and there is another field which is...

This seems like it should be really simple but I can't figure it out. The format of the report that I receive has the date in one cell at the top and the remainder of the data in another place so I would like to grab that date and store it to a variable to that when I import the data to my...

I have two separate forms that will be using some of the same queries. Within those queries I have one parameter which is txtstart that is used in all of the queries. Is it possible to have two separate forms with a textbox called txtstart pass to all of those queries? I am getting an error...

I have a query that calculates the actual salary for each month based on the start and end dates of employment. I've been asked to incorporate salary increases. So I thought I had figured out how I would do that. I have a table that gets imported that has personnel number, salary and date...

I am trying to write a routine that will email from access using outlook. I have it working with a couple of issues. The first is that when emailing from a queried list in access, it needs to check to see if an attachment exists and then email it if it does. The attachments are excel files...

I have a form that has an option group at the top called framemissing. With each selection from the option group, I would like my subform called qmissing to display records from the query created with each selection from the option group. In the properties for framemissing, I have an...

I have two tables with a one to many relationship based on a field position number. I would like to create a form that has two subforms. The first would be a simple table view of table 1 and the second would be a table view the related records in table 2 of the record highlighted in the first...

I would like to email excel files using a distribution list in a table in access. I'm trying to use code I found here but getting "user defined type not found" when I try to run on the DIM myo As outlook.application. Does anyone know how to address? Thanks!! Option Compare Database Private...

I would like to have a query that captures the last record input for each of the last 3 years. I'm doing this with two queries. My first query capturing the last 3 years is: SELECT [Crop Data].[FS Specialist], [Crop Data].Breeder, [Crop Data].Family, [Crop Data].Crop, [Crop Data].[Sub Crop]...

I'm having trouble getting the syntax correct on a sql statement that uses information from two text boxes on my form. Here is what I'm trying: DoCmd.RunSQL "UPDATE [FS Specialists], SET [FS Specialists]![Email] = '" & Trim(Me!txtemail) & "' WHERE [FS Specialists]![FS Specialist] = '" &...

I'm attempting to create a form called Filtered Form that has 3 list boxes. These list boxes can either be used or not in any combination. I would like the results in the unselected list boxes to filter when another is updated. I would like the results of a subform named Child1 to list the...

I have a form that I have list boxes and text boxes that allow the user to create a filter then would like to update those records with text that they've input into the text box. My trouble is that I don't know the sql syntax of using the user input in the text boxes. Here is my code that I've...

I am trying to use the buildwhere code supplied in faq181-5497 and am having trouble. I have 3 multi select list boxes which are all enabled and visible. Each has a Where= statement in the tag property. I cut and pasted the code at the bottom of my vb page and am referencing the code as...

I'm trying to build a multi selection filter form using faq181-5497. I believe I have my 3 list boxes on the form built correctly. They are list boxes that have multi select enabled, are visible, and are enabled. Each box has a Where= statement in the Tag property. I will post how I am...

I have a form that has a combo box to select criteria for a filter. The combo pulls down unique values from the table. The problem happens when the user selects a blank from the combo. This is the code where I'm using the result from the combo box. Case intSelss Set DB =...

I'm trying to filter a query to export to excel. I don't know what I'm doing so I've been trying to copy some examples I've seen. I have a text box on my form that captures user input to use in the routine. In the routine I am really not sure where to put the filter information or how to...

I have a form that will run a report to excel based on whether particular check boxes are filled. I am getting an run time error 94. Invalid use of null whith the first selection only. However if I choose all three it works fine and then go back and choose just the first it works as well...

I'm guessing I've just missed this somewhere in the postings...I don't think this should be hard but having trouble figuring it out. I have a form with an option group used as a menu. After clicking an option another form will come up. Once the user is done with their initial selection and...

I am trying to create a delete query and having trouble with syntax. I have two tables, pending and jobs. I would like to delete all the records from pending meeting the criterea pending.position = jobs.position AND pending.new/replace='R' AND pending.req#=jobs.req# I tried creating a select...