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!

Recent content by aronw

  1. aronw

    sharing broadband 98' & ME style

    firstly i must appologise for my ignorance, i've got 3 computers 2 with 98' and 1 with Win' ME. i have an ADSL modem with 4 RJ45 ports. What i was wondering was if i could share the internet connetion without a server. can i just set the IP of the router as a gateway on each system and plug...
  2. aronw

    Setting up BB internet sharing between 98 & ME

    Hi all, it's been a while since i posted here. so i hope this is the right forum.. i have 3 computers; 2 with MS 98' and 1 with ME'. i need to setup a network so that these 3 machines can share the broadband. is there a walk through thread here or can anyone direct me to one. on previous...
  3. aronw

    Simply puzzled

    Hi, this might be a simple bogal but, I created a query that selects some records bases on 3 fields. (I have a number of fields in a number of tables. All my data is linked together via Accesses very own ID auto-number PK.) Out of my 75,000 odd records 251 pop up fitting my criteria. Now, I...
  4. aronw

    I'm locked out

    Hi GMan2478, I appear to be having a very similar problem. Do you have multiple users using your DB? I do, if all other istances of the DB are closed this problem vanishes. However if not then Access claims that another machine has the Admin. rights. Remedy anyone? TIA Aron
  5. aronw

    old-ish form new records, no display!

    Thanks for your help, have been unemployeed for a bit, hence response time. I got it the form to display all the new records. For some reason my main tables' auto number 'pk' was not automatically adding unique id's. So by copy and pasteing the ID field (which is the same in every table) from...
  6. aronw

    Date field

    Great, thanks KenReay Aron
  7. aronw

    old-ish form new records, no display!

    oh, and my form does not have a filter value.
  8. aronw

    old-ish form new records, no display!

    O.K when I create a query purely based on my main tables, all 40,000 odd records show up. When I create a query based on my main table and one of the other 2 or both only the 1000 show. When I created my other 2 tables (not main) I manually copied and pasted in the ID (auto number PK) field...
  9. aronw

    Date field

    Does anyone know how I could insert a Date field (today's) onto an existing report. This might be a simple question but I have never done it before. TIA Aron
  10. aronw

    I only need One Record

    Yee Haa, Thanks Aron
  11. aronw

    I only need One Record

    When I insert the line: DoCmd.OpenReport "AppointmentReport", , , "ID = " & Me![Company Name] into the click event of my button and run it, I get a runtime error. It says that I have a syntax error missing operator in query expression '(ID = 123Cornish.com Plc)' Doh...
  12. aronw

    I only need One Record

    Thanks Maq, Docmd.openreport "reportname",,,"pk = " & me!formfieldPK Turns into: Docmd.openreport "AppointmentReport",,,"ID = " & me!Company NameID does it? My PK ID is not on the form, does this matter? The problem is that ID is an auto number type...
  13. aronw

    I only need One Record

    little niggle JustMaybe, I created a query as you suggested, PK from main table and then added relevant fields from other table. Now I have a query. This query still displays all the records tho. at this point. I go to report wizard and base it on this new query I have created. The report then...
  14. aronw

    Import table format not expected?

    In Excel row 1 contains things like 'Company Name' 'Post Codes'. I have imported a number of sheets in this same format without a hitch. Thanks, Hjgoldstein and Darrylles. Problem Remains... Aron (Novice)
  15. aronw

    I only need One Record

    Thanks, I have been using wizards to create forms and reports. If this is a big problem / limitation please let me know. So I create a query which includes the PK? (which happens to be a unique ID that access generated - there is no other unique data available unfortunately. All tables have...
See more

Part and Inventory Search

Back
Top