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: *

  1. SweetDot

    Retrieving autonumber

    TheAceMan1, Sorry I meant there are 10 fields for the user to fill but autonumber is not entered by the user. I don't think I can retrieve the number before the record is saved. So I tried saving the record using : DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70...
  2. SweetDot

    Retrieving autonumber

    Hi all, I have a form that allows user to fill out 10 fields where one of them is autonumber. Is there anyway to retrieve that autonumber in the code? I need to do other database operations based on that number, but the number does not appear in the textbox (dataform) until I exit or scroll...
  3. SweetDot

    Linking to csv file on a website

    Hi all, I'm trying to link to a csv file on a website that requires authentication. I know that you can do it in Excel but don't know how to do it in MS Access, or is it even possible. Please help! thanks
  4. SweetDot

    How to link to a csv file from a website?

    Hi all, I'm trying to link to a csv file on a website that requires authentication. I know that you can do it in Excel but don't know how to do it in MS Access, or is it even possible. Please help! thanks
  5. SweetDot

    How to Update Data in a select query joining 3 tables?

    Thank you very much!
  6. SweetDot

    How to Update Data in a select query joining 3 tables?

    Hi all, What settings do I have to change to enable data editing in a select query? The select query joins 3 tables together and is displayed in a subform. I have made sure that the setting for uniquerecords on the query is set to No. is there anything else I should be doing? Thanks!!
  7. SweetDot

    Inserting Newline Character into Word

    Hi all, I have a function in SQL that stores a string that will be inserted into Word during mail merge. I would like to add a newline character into that function in SQL so that when it gets inserted during mail merge MS word will recognize the character. I have tried using CHAR(13) +...
  8. SweetDot

    Enable Security -> Workgroup Administrator option

    OK, I thought if I got the network security people to get me the previous admin's login I would be able to change the permission, but now I have it, and Security -> Workgroup Administrator still doesn't show up. I can't find the .mdw file anywhere, should I be creating a new database and...
  9. SweetDot

    Enable Security -> Workgroup Administrator option

    I see, thanks very much though.
  10. SweetDot

    Enable Security -> Workgroup Administrator option

    Hi, I have just taken over a database from a person who has just left the company. He has set the permissions on that Access 2000 project that no users can modify the permissions to access tables, queries etc. I need to get in to give an user access to a report, but Tools -> Security -...
  11. SweetDot

    How to save a excel macro to use in other excel sheets

    Hi, Is it possible to save an excel macro so that it can be used in other excel sheets? Would the export and import function work? I want to be able to run the same macro on many different files, and these files are data files created by another program, so there's no way to know what the file...
  12. SweetDot

    Excel Query Editor acting weird

    Hi Skip, I did try to edit the query without saving, but everytime I hit the exclamation mark to run the query, and I go back to the SQL query window, the query would be changed. And as you can see in the query I pasted in (the 2nd part), the parameter date value that I entered would be "?"...
  13. SweetDot

    Excel Query Editor acting weird

    Hi all, I've been having problems with a simple excel query. What I want to do is to have this query done on an external data: SELECT TSC_Change_Request_v2.Status, TSC_Change_Request_v2.CR_ID, TSC_Change_Request_v2.Objective, TSC_Change_Request_v2.Planned_Start_Date__mm_dd_yy_...
  14. SweetDot

    Adding Scrollbar to frames and Subforms

    Hi, I have a main form that needs several split windows. Which control should I use to create those split windows that will provide me with the scrollbar function? Each split window needs its own scrollbars. Right now, I have two frames (each frame has several textboxes) because there are so...
  15. SweetDot

    TRANSFORM crosstab

    i need to use the result from the 2nd part (the running total) to plot a chart...so i think i'll need to use SQL instead of the report.. here is the query: TRANSFORM Sum(tblSource.[A Pax]) AS Pax SELECT tblQtrHrs.QtrHrTime, 'A' AS Bound FROM tblSource, tblQtrHrs WHERE ((Not...
  16. SweetDot

    TRANSFORM crosstab

    I don't get it. A report? The result from the first part is in a query right now. So I just have a table with two columns. How do I use the textbox?
  17. SweetDot

    TRANSFORM crosstab

    yeah, i'm counting the passenger numbers within a time slot... tblQtrHrs contains just a list of time slot of a 24 hr period ...so it goes like this 0:00 0:15 0:30 0:45 1:00 ....and so on I've actually just solved the problem with the time slot....so it is now giving me correct numbers... but...
  18. SweetDot

    TRANSFORM crosstab

    I've tried to do that...but it's still not doing what i want it to do:...this query was written by someone else, and I don't know who that person is, I've just been told to fix it so here is what i'm trying to do: I am given a schedule of flights, each record has both arrival and departure...
  19. SweetDot

    TRANSFORM crosstab

    Hi, What does Transform do? I have this query that is giving me the wrong data, I just can't figure out what's wrong: i'm trying to figure out what's wrong with this query: TRANSFORM Sum(tblSource.[A Pax]) AS Pax SELECT tblQtrHrs.QtrHrTime, 'A' AS Bound FROM tblSource, tblQtrHrs WHERE ( (Not...
  20. SweetDot

    Concatenating Two Records

    thanks so much everyone.

Part and Inventory Search

Back
Top