Search results

Thanks Ridders If i knew where the 'slow tear down my face' emoji was i would use it now ;) Spent a good bit of time building that nav form to make it look pretty so hoping you may be wrong but so far with all your help you never have been. Ill have a look at the links you mentioned...

Hi I have used access' built in navigation form. Within the first tab of the nav form i have put a subform (subform1) that has a header with some filter comboboxes and in the detail section of the subform i have a further subform. If i open the Subform 1 outside of the nav form and change...

Hi, i am tryng to use the inbuilt navigation form on access. NOt sure if that is done thing but seems useful. ANyhow my issue is when i go form one tab to the other the colours change slightly to show hover. But when i click on when the tab goes form for example blue to grey which is great and...

Hi I'm lookingfor a source of additoional pictures other than those in microsoft access. Is there a library of standard images that are applicable to access ani can add to the program?

I guess 1 alternative would be that if cbo_cat is empty i load one qry and if not refresh subform with another qry???

Hi Mark. My IDs are numeric fields not text fields. If i switch the code to what you have suggested i beleive when the form opens it will show nothing in the subform as nothing is selected or is my understanding incorrect? THe idea is that at start all info is shown in the subform and as i...

Sadly no joy with that approach as it then says criteria too complex to evaluate and crashes it. If i remove the Like and "*" then it doesntr achieve what i want as it doesnt show all the varieties when form loads as i have selected a category or genus so it wont show anything. I think the...

HI I have a main form with a category cbo, genus cbo and the na textbox to enter a vareity name in. I have a subform that when the main form opens its shows a list of all the varieties on the database. When i choose a category form the category_cbo it filters the subform list to only show...

Sadly no, i just used names as an example. IN fact what i am using it for is plant species names. For example "Soleil D'Or" Cheers

HI I have the following code to ensure that all first letters of every word in a textbox are capitalised: Dim LResult As String LResult = StrConv(Me.Txt_NewTier3.Value, 3) Me.Txt_NewTier3.Value = LResult Works fine until i enter someone name such as Mike O'Riley and the end...

Nailed another for me Arnel. Many thanks

Hi, i have a textbox (Txt_Newtier3) and in the afterupdate event i check whether the name i entered into the textbox already exists in the bound table using a dcount. To clarify i can enter the same name in the textbox as long as the parent name is different. For example, i could have 2 brands...

Brilliant, thanks for both suggestions.

Hi I currently use the following code to check if a textbox is blank when i click an enter command button: If Nz(Me.Txt_NewTier1, "") = "" Or Len(Trim(Me.Txt_NewTier1) & vbNullString) = 0 Then ' Enter message here Exit Sub else End If My question is is this the...

Hi Pat Apologies the form is not unbound it is bound to a table. I have controls that are unbound in the form and when i click my enter command button it runs tests on each input i.e. are they empty etc or compliant with the format of table etc and then transfers the data to bound textboxes...

Hi I have a input form with a subform showing what i have previously input i use the following code on an enter info command button Private Sub Cmd_enter_Click() Application.Echo False ApplyData DoCmd.GoToRecord , , acNext 'DoCmd.RunCommand acCmdRecordsGoToNext Me.Sub_Batch.Form.Requery...

Hi Im trying to create a cutom right click option in one of my forms. I watched a youtube video and copied the code. He added 5 option to his right click but rather than type all out i wanted to check it worked with one first but it didnt work Private Sub CreateSubFormShortcutMenu() Dim...

THe home ribbon is all greyed out where you would usually adjust the font size for a datasheet table or query

Hi I have a subform that is set as datasheet view. I have run out of room so need to shrink the font a bit to get all my columns in but cant seem to figure out how to shrink the font. I change font size in subform properties but when switch to datasheet it just stays as standard size font...

Cheers JHB that helped me solve the problem. Was pulling in from multiple tables with multiple joins so needed to delete some of the joins.