Search results

Have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=167865 Posted a couple of samples so the code is viewable you will need to learn/know alittle about VB to get best results. good luck John

You need to put the code Bob specified in the OnClick event procedure of your command button. YourFormName = The current form that you are using YourControlName = Name of the text box you want to copy value to (not the caption the actual Name) Me.YourFieldYouWantToCopy = Name you want to copy...

Doh!!! forgot the bound field of the Combo box probably not the employees name....

Select case is your [Expression] so maybe: Dim stDocName As String Select Case Me.cboEmployee Case "Richard" stDocName = "Main_Menu" DoCmd.OpenForm stDocName, acNormal End Select Assuming that the Case Select is going to be contained in the body of code for the password check...

Well that explains why both the versions that I have work they are identical, no changes/differences between field names.... If you want to change a field name do it in the source table then any related queries (see attached has been altered to your names) also the control source of the...

I would think that when using a continuous form it is gaining focus on each change in the search text as it may be treating it as a new event eg. another record found so another record/line/box added to the continous form? just a guess I'm throwing out as it works in list box view... maybe...

I have to be honest I don't find the form very well structured and I am not sure what you are trying to accomplish? That said it may be exactly what was needed for its original purpose and I'm not being critical of the original author we all do things in different ways to accomplish our goals...

When I you having the problem as both versions seem to open fine on my system?

Can you zip they database and attach so I could have a look? Belfast is 30 miles north nice place :) regards John

Is the forms datasource the table or a stored query? If the forms datasource is a query and you have altered table names you need to update the query you will probably see a field in the query saying something like Expr [tablename].[oldfieldname] its asking you where those are when you try to...

You are best using the built in tool "Database Splitter" found in Tools>Database Utilities this will split your database into 2 parts Frontend (FE) that will contain all your forms, modules, queries etc and Backend (BE) which will contain all your tables/data. Locate the backend on your server...

You build a report based on your a stored query and in (like you one you have called qryClientData) then in the criteria of the the ClientID field put something like: [Forms]![frmSearch]![ClientID] Then have a command button on your form that opens your report. Good luck John

Don't matter what the field format is the column count is set to "2" in the lookup same as any combo box on a form might be so that the data displayed not actually stored bound column = "1" thats the tables actual stored value hence Number....

Have a look at the attached it will do what you want (haven't put any validation rules in you might be better using comboboxes to limit selections anyway) Its long winded I admit and the code is in form OnCurrent/OnLoad and MenuOpt AfterUpdate the best I can say is that it works and pretty much...

Without knowing exactly what you have done its a bit hard to advise as ruralguy said earlier you would need to clear entered text if user changed selection maybe: Me.TextBox1 = Null To be honest could do with seeing an example of what you have done rather than giving you suggestions that...

Dohh!!! sorry my mistake totally mis-read the problem thanks wiklendt :)

Might not be the format in sense of being text but have had problems with Dcount if the table and form fields are not formated as the same data types eg. table is text and form field is number plus you have a - symbol or special charcter used in the text as a seperator try just a straight...

You could use OpenArgs to pass the values from one form to the other but you will need some coding experience/understanding to accoplish this. Also you would need to make sure that you have correct table structures to pass/recieve the information and as we don't know your experience level its...

In the afterupdate try inserting Me.Requery as for the underlying records being altered it sounds to me like incorrect structure or use of the combo box to display data do you mean you are using the tables primary key in the combo box and selecting a record in current form view. Seeing an...

Have a look here: http://www.access-programmers.co.uk/forums/showthread.php?t=167898 Should be roughly the same think you want to do :) good luck John