Search results

It might be this , quotes, [person ID] = single quote, quotes, & Me.[per_id], quotes, single quote, quotes. So, DoCmd.OpenReport "rptWholePerson", acViewReport, , "[Person ID] = '" & Me.[per_id]"'" so its parsed correctly. gregorg.

DoCmd.OpenReport "rptWholePerson", acViewReport, , '"[Person ID]=" & Me.per_id' ?????? person_id = Me.per_id DoCmd.OpenReport "rptWholePerson", acViewReport, , '"[Person ID] = " & person_id' ?????? Its just getting the right syntax ?

thanks for the reply, I will try both these thing out.

i have two front end databases with one back end, the two front end use linked tables to the back end. One front end is on one computer with the back end in the pulbic directory, The other front end is in the pubic dirtectorty of the other computer. I can access both and use both front end...

can i use an insert into sql statement in VBA ? how would this look ? gregorg

hi, i have a database with a primary key that is autonumber. my client deleted a record so the autonumber field is not contiguious. ie it goes 166,167,169, so record 168 has been deleted. this is throughing out the number system she has. i am trying to insert a record 168 into the table but...

I have managed to set up 2 databases as 2 seperate front ends, and 1 back end access database with the tables only (using linked tables for the 2 front end programs). But when I try to do the same across a network i get a read/write problem, ie the front end programs open "read only record set"...

I have managed to set up 2 databases as 2 seperate front ends, and 1 back end access database with the tables only (using linked tables for the 2 front end programs). But when I try to do the same across a network i get a read/write problem, ie the front end programs open "read only record set"...

will try this - The other test you should do, go to each desktop machine, navigate to the location of the back end database, once there, create a simple text file, save it, open it, add some text and close it. If you can do this, then that proves you have read write capabilities to the back end...

there are 3 machines, 1 desktop laptop 1 laptop 2 there is not "server" just a wireless hub. on laptop 1 is a front end program (with linked tables to back end program) and the the back end tables only ptogram. on laptop 2 is a seperate front end program with linked tables to the back end on...

hi, i have 2 acess databases on 2 different machines on a net work. the two programmes both have linked tables to another access database on one of the machines. If both the front end programs are open at the same time there both open as "read only recordsets" . My idea was to have both the...

ok i can look into this, just have never done it before, will look at sharing options, will look at it if only 1 front end or 2 are open at the same time, thanks

I have tried to do this but to no avail. Can you create a blank table with the same fields and then generate 2665 records via VBA and then append the current table without the ID field ? I don't know if you can do this. Sorry

Hi i posted about spliting a database, which i did, it was to alllow more than one user to use the database at the same time. I have 1 machine (#1) with the tables only, and on the same machine a front end for the data with linked tables. On the other machine (#2) i have a front end with linked...

Thanks. -------

When you are writing data into a record on a form the icon changes from a triangle to a pencil, when you have finish writing/editing the data the pencil changes back to a triangle. What event is this ? So I can back up the data each time it is changed ?. Is it "On Change" ?

but you still have to do linked tables ? so they are using the same data, or do you just have 2 users using the same program file ?

Thanks Gregorg

:confused: hi i have written a database for someone in access. They now want to have another user on the same wireless hub use the database at the *same time* as the first user ? I don't know how to do it or how it can if it can be done ? I also thought of writing some forms in visual baseic...

how do i access a text box.text from a subform ie from the parent container ? how do i write a new record to an unrelated table ? g.