Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Delindan
  • Content: Threads
  • Order by date
  1. Delindan

    append records with text converted to a date

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

    I am appending data from a temporar

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

    Store date from cell in spreadsheet to a temporary variable

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

    two different forms passing parameter to same query

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

    Updating current salary based on personnel number

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

    Check for attachment

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

    option group to display query

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

    Subform contents limited by other subform

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

    email from access

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

    Summary Query

    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]...
  11. Delindan

    SQL command using textbox from form

    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] = '" &...
  12. Delindan

    Filtered Subform

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

    update using form created filter

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

    Selecting Multiple criterea from a form using faq181-5497

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

    Problems building query from form

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

    problems with blank text field in filter

    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 =...
  17. Delindan

    filter query from form to export to excel

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

    Problem with Checkboxes

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

    Reset Option Group Values

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

    Delete Query

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

Part and Inventory Search

Back
Top