Search results

Any one out there who is interested in MMORPGs should take a look at this site: http://www.sylorn.com/ It is an early stage MMORPG and anyone who signs up in the forum will be able have an input in the design - storyline, game suggestions, art work, etc. I just recently found it and thought...

Go to sheet Below is very simple sub which you can add to a button click to go to any sheet. Sub GotoSheet() Sheets("YourSheet").Select End Sub Cheers Nicolas

Link Here is a link that may help http://www.blueclaw-db.com/comboboxlist/multiple_dropdown_fields.htm :)

Hi there, I am having a little trouble with this. I am trying to get this code to work in order to show some controls: Private Sub OpenCToEdit_Click() 'Opens the form in edit mode On Error GoTo Err_OpenCToEdit_Click Dim stDocName As String Dim stLinkCriteria As String...

Yes, thank-you

Hi just a quick question Could someone please help me with the correct syntax for changing the allow edits and additions property on a form in code. I have a form which is locked for these things but I want to allow some users the ability to open the form in edit mode in order to add new...

Thanks for the suggestions, it was a margin problem, which was rather confusing as I know the printer can print to the dimensions I set. However access seemed to feel that it knows best!

Thank you, I fiddled around and managed to get it working. I did not need explicitly save as you said Cheers

I have tried searching, but have not foud anything that quite fits the bill for this. I would like to add some code to my event procedure for opening my form so that when it opens a field has a value entered in it and then the record is saved. My form name is frmCompanyClients based on...

Re Create a subform using the toolbox and the wizard will run you through the process, you will need to specify the link between the two forms, ie Client_ID (this will be the same link you see in the relationships window) For the report, I suggest you create a query based on the info you...

Thank-you very much, that worked first time.

Just a quick question, I can't seem to get this right (as usual :confused: ) I have a form and I want the label in the header to display the text from a field in a related subform. I have tried the following syntax to no avail: =[Forms]![sfrmCompanyName]![LastName] Any suggestions Thanks in...

Hi, I'm not entirely sure what you mean, do you want to link the form to your table? If so you need to select your form in design view and then on the property sheet set the record source as your table (data tab and then top box, you should be able to select from a list) Then for each text box...

I have a form in which several fields have default values. However, when I create a new entry and save it only saves the those default values in fields which come from the primary table. Fields that in subforms that come from related tables are not automatically saved. For Example Primary...

I am having trouble with a report which was created through the label wizard and it is just not showing all records. I am running the report based on a query. When I do a normal report with the same fields and based on the same query, I get all the records. Has anyone one else come up against...

Hi I am having trouble with my database and I think it stems from the way that I have set up the tables and relationships. The problem I am having is that I split my clients into two types - private and company clients. However I am now stuck as to how to query both sets of data. I want the...

I am getting myself into knots trying to solve this can anyone help: I need a calender so that the user can book and check availability of courses for each date. ie course 1 has 5 places on this date, once one is booked then there should be 4 places left. Does anyone know if there is a...

I wonder if anyone can help with this: I have put a selection query as a subform in a form which shows client details. When the form opens from the switchboard it asks the user to enter the clients unique number and then the query links the number to the client ID (autonumber) which then...