Recent content by merlin777

Thanks, Mark. I'm confident I can do the export myself with instructions such as yours but it won't really work for my end users. The display/print of a timetable needs to be transparent to them. I'm caught between a rock and a hard place. I can prepare a timetable printout fairly easily in...

I'm building a patient/therapist scheduling database. The timetable reports are very tricky to do in access and i'm only a novice but in excel I can do them relatively easily. The database is to be used by busy therapists with little expertise in access and excel other than using an application...

I accidentally changed a query to a delete query. I'm not sure how I did it and now I can't see how to change it back. Please could someone advise me? TIA

Fixed! Thanks for all your help guys. I've learned a lot. I tracked it down by selective deletion. Turned out to be i'd been clumsy when dragging and dropping my relationships and one of the tables was related by a field other than its ID field. Phew.

Aha! Schoolboy error. For anyone else who's thick like me, when you right click to find the paste structure option, it doesn't appear until you click on 'paste'. Slightly counter-intuitive. Don't like clicking on 'paste' because you assume that's what it do, rather than offering more options.

Thanks, CJ. All the number fields in my main table are 'long integer'. What is it they need to match with? The type mismatch error is in a query and I get a type mismatch in expression error even if I just put the ID field in 'field' in the first query column and the main table in the table row...

I'm using 2007 - does that make a difference? Doesn't look at all like your picky.

can I just do a sanity check, too? My main table has an ID field (autonumber), therapist field referring to the therapisttable (number field), patient field referring to the patienttable (number field), therapy field referring to the therapytable (number field). The patienttable, tehrapisttable...

Backup - check :D I've copied the table in the navigation pane but I can't see how to 'paste with structure only'. I can't see this option on the right click menu or a 'paste as' option etc - and when I do find it, where do I paste it to? Appending the data is just a cut and paste job?

OK. I managed to lose the error. I needed to 'show all relationships' and then not delete the tables in the window but actually delete the relationship lines between them or they don't actually get deleted. Not very obvious! Now I've been able to change the datatype to numbers.... but I've...

Where do I find the ellipsis to invoke the GUI? Its usually in the property sheet but I can't see one anywhere in design view?

I hadn't but I have now and I'm still getting the error.

Aha. I found the SQL view in the SQL menu. I guess the design grid is the name of the table at the bottom of the screen I have been using so far?

If I was using SQL, where would that go? As you can tell I'm a novice.... but I'm getting the sense I'll need to embrace SQL soon!

i'm getting 'the syntax of the subquery in this expression is incorrect' In the fieldbox of the first column of the query I have: SELECT ID, [FirstName] & " " & [surName] As FullName Have I made a typo?