Search results

I feel the best way to use this forum is ask for help when you need it (MAKE SURE you've searched for other people asking similar questions before you ask) and have a look at other peoples' problems, and if you can help, then it completes the cycle :)

A database for a car hire company is a good one to work with. The students will have fun making up all the cars that they want to be able to hire (especially with boys), and validation rules and sorting works well with reg. plates, car makes etc. It's also got a lot of scope for evolving as...

It's funny really, if someone had a personal database they needed for something I'd be happy to do it for them if I had some free time, but for a small business thats making profit, why is it in anyone's interest to help someone else make money at own expense of time?

So basically all you need to do is get some code to select the correct price from the correct table selected by an field in the record? That should be easy(ish) to do with VB.

This has a link to a guide on how to set it all up: http://www.groupsrv.com/computers/about278983.html This isn't as helpful but might have a few pointers: http://www.campus.ncl.ac.uk/databases/dotnet/aspdotnet.html#eg Failing that, these hosts will set up all the complicated stuff for you...

I've just tried doing what you're doing, but without the queries. Just 2 seperate subforms accessing data from the same table. They both allow data to be modified. However if I put RECORD LOCKS: ALL RECORDS onto the subform I want to edit, I can edit that form and not the other. I don't know...

I don't know if you've solved this problem already, but I'm a student with a good knowledge of basic database issues like what you're doing. If you still want one doing, drop me a message and we could have a chat about it. Don't worry, it wouldn't be a $50 an hour jobbie!

Just as an idea, can you open the read only subform as a 'read only'. If you go onto form properties and select 'record locks' - all records. I think that might be different from just locking the fields, as it tells access that everything is definately read only. Let me know if you have any...

So what exactly do you need doing? What bit of your code doesn't work?

A bit of a botch job (but easy to follow) could be to create a text box on the form that is set to it's value+1 each time the autokey function is pressed. Then you can edit the macro to edit field(value) each time you press the button. Sorry if this isn't any help. Paul

In the best possible tradition of using duct tape to fixa problem, I just closed the form at the start of all the macro running, and just copied the data needed on the form to text boxes on the main menu (which remains static) May be a botch job, but no-one's going to look at the workings of it...

Are you asking for advice or just showing what you've done? Paul

I have a form that is open, and needs to be closed at certain point in certain macros. However, sometimes the form is already closed when the macro calls for it to be closed. Can I just do something to ignore the error message saying the form can't be found, or is there a way of putting a...

I have a combo box with data source as a query. I want to select another field in the query from the record which is currently selected to use. Is there an easy way to do this? Thanks, Paul

For some reason changing the AS to [read or write read only] and expanding the other set of fields (and removing a conflicting one) worked :) Oh and the [ ] probably helped as well! Thanks

Putting this in the field box in a query: read or write: "r" should create a field called read or write with a value of r in each record in the query, shouldn't it? Why doesn't it, and how can I make it work? Cheers, Paul

Thankyou for help guys, turned out the the blank values were zero length strings as well as null values, so had to use IIF with an OR clause in, but works 100% now. parm description: IIf(IsNull([curr value table].[parm description]) Or [curr value table].[parm description]="",[reference...

IIF((isnull [curr value table].[parm description]), [refererence Parms].[parm description], [curr value table].[parm description]) AS [parm description] That's what I've tried to use but says it has a syntax error, any ideas?

I have a field in a query that I want to select the value from a field, but if the value is null, then to select the value from the same named field in a different table. Basically the whole point is to use the given description unless one doesnt exist, where the default one will be inserted...

Append I think?