Search results for query: *

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

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

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

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

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

Great, thanks KenReay Aron

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

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

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

Yee Haa, Thanks Aron

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

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

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

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)

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

Appreciated, I don't think I was clear. I should see 1 of 10,000 records at the bottom of my form as that is the number-ish of records I have. However, no more records show since I created the form. So what I see is: 1 of 1030. It is not just a few fields not importing properly, it appears to...

Thanks Darrylles, I have tried sorting the data differently in Excel but no change. I did not mention that I am importing all these sheets and adding them to the same table. My first row matchs field names etc. Still probs. tho

I have a database which I have created by importing Excel sheets. However some of the sheets do not import. When trying the message given is, "import table not in expected format". This excel sheet is exactly the same as the others that have been imported successfully, just different...

Is the a simple way of generating a report that just displays the record i'm viewing in my form rather than all records? TIA Aron

I have a created a database with roughy 1000 records. I have created a form etc. However when I added records to my contact_details tables (imported from excel) my form does not recognise the fact that there are more records. The form is based on this table. Does anyone know what this is about...