Search results

OK I have managed to fix this! Basically I changed the record source to a query of all client details, then used the combo box as a parameter to drive the query. I then added IS NULL to the criteria too and it worked! I tried doing this before but I couldn't update the query previously...

OK this is infruriating because I know I'm very close. Currently it loads up a blank record, but then when I select client number form the combo box, it populates all the subforms correctly but the text box with client name in the same form doesnt work...its just blank. The SQL behind the...

OK apologies for being very dumb. Have tried to get this to work without asking another stupid question but how do I get my text box to then populate with the client name selected from the combo box? Previously as the form was bound to client details it was able to pick it up, but now it...

Ok I have typed the following in record source: SELECT * From tblClientDetails Where False Or Select * From tblClientDetails.ClientNumber = 0 However I'm getting an error message which says "Syntax error. In query expression 'False or Select * From tblClientDetails.ClientNumber = 0'. I played...

Hi David Thanks for the reply. I'm not very advanced when it comes to SQL/Access so do I literally type what you have said in the record source box? Or do I go in SQL design view and type it in? What exactly is PK?? Thanks for your help Brian

Hi everyone I have a form which is bound to a table 'Client Details'. I then have two fields on this form, which is a combo box of "client number", and a text box "client name" that populates when the combo box is updated. I then have two subforms, which update fine when the combo box is...

Thanks for the quick reply David. That works but for some reason I can't edit any of the details on my form. I've ensured that cascade-update is on, and the form isn't locked so I don't know why....any ideas?

Dear all I am a beginner who is beginning to lose patience with Access! I am positive this is a common problem but just can't find it in the forums or else am searching for the wrong thing. I have a form that lists my client name and their orders below it. It is based on a query which pulls...

Dear all Thanks for your input. I've got the fundamentals of my database in place but I think now I have to get down and dirty with VBA. I've ordered a book which should hopefully arrive tomorrow (VBA for Dummies!) so that should help me interpret the useful code posted earlier in this...

Thanks a lot for your detailed answer! I have absolutley no VBA skills whatsoever, I think I may have to buy a book that can help me out with that. I'm starting the database today so will be sure to refer to this post lots... :)

Sorry, I should clarify - I'm using MS Access...I just abbreviated database to dbase. Do you know if those requirements are possible in MS Access? Thanks

Hi I've just built my first Access database for a work project and now I have my sights set on something higher! Before I begin building the dbase though I wanted to know if the following was possible, and a brief indicator of what it would require, i.e. VBA code etc and level of difficulty...

Hi Paul I used the code that you gave me earlier up in the thread...I have however managed to suss out the problem by changing it to a 'Command Button', clicking Build Event, and then putting your code in there. That seemed to do the trick! Thanks for the help tho, really appreciate it. Have...

I've just noticed a slight bug with this button. I was using a toggle button with the code and when it is pressed it enters tomorrows date. However, if you unpress it (in case you make a mistake) it still enters it as tomorrows date (when I want it to go back tomorrow). I have the VBA code...

Sussed it! I put IS NOT NULL in the originating query in the field i didn't want to appear...

Hi once again I have a report, with a subreport inbuilt. In the subreport, there are null fields. They don't come out on the subreport, but they do create a 'blank space' so that there is a whole load of blanks before fields are returned. Illustration: NOTES (<---this is a label) <BLANK>...

It works! Hallelujah....thanks very much! Access is very frustrating for the beginner I have to say but have learnt a hell of a lot in the past few days...this website makes my life a lot easier! Thanks again - no doubt I'll be back with another query soon....! Brian

Hi Paul Sorry I posted that last message before your reply. I've updated DateField to Date and that seems to have done something - if i go to my table now that record is just 'blank'. I would rather a toggle button than a drop down list for date if poss... Thanks Brian

This is what the VBA window looks like (and I presume I don't put it in the immediate window).... Private Sub Toggle17_Click() Me.DateField = Date + 1 End Sub The brackets after date disappear when I save it....

Hi Paul OK I've done that but now get the following error message: "Compile error - Method or data object not found". I posted that code exactly where the VBA window popped up - is there something I'm missing?