Search results

  1. E

    Question Exporting a snapshot?

    This sounds like what i'm looking for. Any other info on how to do it? I understand the concept, but its the underneath code that i'm not sure what to do with
  2. E

    Question Exporting a snapshot?

    Hello, I've been researching but haven't found this yet. I'm looking for a way when I click a button, a screenshot or snapshot is taken and saved to a specific file location. Anyone have any thoughts?
  3. E

    Auto Fill

    I'll take a stab at it... Is all of the pricing data in the table? If so, let's call the ECPS COST field [Price] and we'll call the list box [PartNumber]. [Price]should have a Row Source something like: SELECT PartsQuery.Price, PartsQuery.PartNumber FROM PartsQuery WHERE...
  4. E

    Combobox shows AutoNumber instead of selected field

    Thanks for the tip about saving as an 03 database, i'll do that in the future. I was able to fix this issue with the column settings, thanks for your input (both of you)!
  5. E

    Close without saving button?

    For me it works as I am logging any time anyone goes to the form and enters data. My way still captures that log. I'm sure there is a better way, i'm still pretty new to access.... by no means am I saying do it my way, just sharing a work around I use.
  6. E

    Combobox shows AutoNumber instead of selected field

    Hello, I built a database for tracking absences and tardies that multiple depts use in our company. The request was made to add a department filter, which I am doing and almost done, but i'm running in to a problem. On the opening page, there is a report section that originally had 2 drop...
  7. E

    Close without saving button?

    vBaInet's way seems easier, but here's the work around I made up... Discard sets a specific field to blank, and then I have a scrub query that runs in a macro to delete any row with that field blank.
  8. E

    Running a query with dates from another table

    Thanks for the reply. Someone else mentioned that I could try utilizing vb code to do it...think this would work?
  9. E

    Running a query with dates from another table

    SELECT DISTINCT dbo_AS400_SerialNumber.PO_Number AS [PO#] , dbo_AS400_SerialNumber.Part AS EDC , dbo_AS400_SerialNumber.ReceivedNumber AS Recd , dbo_AS400_POHEADER.Supplier AS Vendor , dbo_AS400_SerialNumber.DateCreated AS [Date] INTO [New SN] FROM maxdate2 , dbo_AS400_POHEADER INNER JOIN...
  10. E

    Running a query with dates from another table

    Hi, I'm running a query that needs to pull dates from another table as its criteria. As in, I have 2 fields in another table: [start] and [end] I go into the query and on the date criteria: "Between [date range]![startdate] And [date range]![enddate] I run this, and it never ends...Access...
  11. E

    Update form/query

    I've made some progress, so i'm going to end this thread and start a more specific one inside of the queries forum.
  12. E

    Update form/query

    ooh...uh....yea :) I'm trying some things right now with max date and today-1 to create a query range. My only problem is, duplicates can still be ran.
  13. E

    Update form/query

    I got step 1 and step 2. Step 3 is where I really get lost...I don't know how to do the unique index?
  14. E

    Update form/query

    Hi, I need some assistance on a form. I have a query that runs against 4 linked tables and pulls the data to a local table. I would like to create a form that shows the last time the table was updated and then a button to update the local table. It should go run the query from the date it...
  15. E

    Exist Query help

    Hello, I'm running in to some challenges with a query. I'll give you the cliff notes version. I'm trying to compare accuracy from what our vendors say they are sending us to what we actually received. I do a left join from what we received to what they sent and also some inner joins based on...
  16. E

    Report card help...

    Thanks for the reply, this helps. Could I just pass the MaxDate through when I use the form to select which person's report opens up? Instead of using a separate query?
  17. E

    Report card help...

    Hello, I'm creating something that will be used like a report card here at work. The manager will be printing this report out, sitting with his coworkers, and grading them on their duties. I have the form created that captures the data no problem at all. Here is where I am stuck... He wants...
  18. E

    iPhone, is it worthit?

    best purchase i've ever made possibly...that and my hdtv :)
  19. E

    Regarding Page setup for Report

    According to http://office.microsoft.com/en-us/access/HP051883621033.aspx You should be able to just use page setup... Unless i'm missing something
  20. E

    Counting check boxes on a form

    Ok, so this works....Which led me to my next problem. I want to be able to total all columns and do other evaluations of the totals, but don't want this extremely long convoluted line ([Q1greeting]+[Q2greeting]+.....). My thought was I could do it through vb code. I went to declarations and...
Top Bottom