Search results

Why not set the background image of the form as the logo? Ahh... do you mean floating buttons as an animated form?

Do you mean creating a new record if one does not exist? e.g check to see if a record under that name/number exists and if not create one passing the name from the form? If so a combination of Dlookup and openargs would do the trick but not quite sure what you are trying to do. Give a bit...

Yeah sorry was something I stripped out of another database I had been working on as a test example rs = recordset must have slipped past me :o

These are things we all learn as we go along mainly the limitations of what you can/cannot do with a relational database be it access or any other. Yes the problem is with the query but I think it is also with the concept of what you are trying to do. I assume you don't actually want to...

Ok there are a couple of problems with your table/query structure that is why you are showing 1818 records the query is creating every possible variation as a record then when you use the unbound combo boxes to filter it is creating yet another record in the underlying table. You really need to...

No I meant zip the database up and post it so I/we could modify the code and post it back sorry if I wasn't clear.

You need to link the 2 tables with a foreign key eg. the autonumber allocated to the participant should be in the source table to link your "Source" to the participant without this you do not have a viable structure. Have a look at the attached example of cascading combos and you should get the...

Could you attach an example of your current DB would be easier to put the code in then walk you through the steps of how it is done?

Did something similar to rate a risk assessment I used the following in the forms on current event procedure: Dim strlow As String Dim strMed As String Dim strHigh As String strlow = "low" strMed = "Medium" strHigh = "High" If [Score] <= 7 Then...

What conditional formatting are you using and where are you putting it?

Ok so what do you want to do? do you want to show certain records in your data sheet view depending on selections in main form? If so something similar I did and example for using combo box and dates is attached but not really sure what your trying to do...

Depends what type of control/field your typing it into only the memo field/control allows the use of return/enter as far as I am aware but may be wrong...

Can't really tell from the image but have you filtered a selected table into a different view or are they a query? In other words are A,B,C,D etc tables contained information on all processes that are filtered by selection... If so actually viewing them may be a problem displaying information...

Are you using the same OS and version of access? Also is your screen resolution different perhaps... Would be easier if you could post a sample as it may do the same for someone here also as you suspect may be some local settings on your PC. Have experienced some odd behaviour with subforms...

Works ok for somethings not for others.... if used best off designing your forms at the lowest resolution your db is going to be used on and "upsize". Can be really difficult to get to work well if you have detailed subforms within the form and selecting the appropriate font size/type.

Never tried to automate it but try here for info: http://office.microsoft.com/en-us/access/HP051866541033.aspx Access 2003 command: http://msdn.microsoft.com/en-us/library/aa220766.aspx Access 2007 command: http://msdn.microsoft.com/en-us/library/bb214134.aspx Had a quick read and should...

:o I meant Default value as I said earlier :o

Usually works ok for me on the forms control value as the form is passing/updating the field data in the table (same as when you enter information manually) your other date field will not be effected unless you do the same for that control/fields property settings on the form.

Where have you put it, I usually put mine in the default value of the control on the form using =Format(Now(),"dd,mm,yyyy") or "mm,dd,yyyy" in the US. regards John EDIT: = now () Usually returns 01/01/2009 15:42 etc.... eg. Time and date which may not be what your table value is formated to...

If your using access the above are your only options over a network to be honest... having not used a citrix server system I cannot advise on this but depending on how many users will be connected you may even need to upscale to SQL. I think what you are trying to accomplish may be beyond an...