Search results

Thank you so much for looking into it. There were so many poorly designed features in it that I really struggled to fix some of these things for them. I'll try to fix up the form names and control names and then hand it back to them. They've hired a data entry person to start work on it but...

Thanks, will look forward to any ideas. I know SQL because its used in SAS, but I don't understand the form and subform references that Access uses.

Thanks - I've attached the database as a compressed file (hope it works ok). It has no data except for a few test records. The team paid a guy to build this db for them but it was full of errors and spelling mistakes etc, so they asked me to go through and fix it all for them. I use SAS not...

Yes, that is the link that I have been referring to and as I've already said from the beginning, I can't get it right after trying several combinations. Is there anyone who can help me with this please? Anyone? ANYONE?!!! I thought this was a fairly simple beginners question and that someone...

When I open it from the main form (frmMain) it has the same path: [Forms]![frmDeceased]![cbo_ROHE] I thought that I should somehow refer to the frmMain in the path, so I tried: [Forms]![frmMain]![frmDeceased]![cbo_ROHE] But that didn't work. Am I missing some combination of exclamation marks...

The first combo box (Rohe) is just populated by a simple table named tbl_ROHE_IWI_lookup. The query is: SELECT tbl_ROHE_IWI_lookup.ROHE, tbl_ROHE_IWI_lookup.Order FROM tbl_ROHE_IWI_lookup GROUP BY tbl_ROHE_IWI_lookup.ROHE, tbl_ROHE_IWI_lookup.Order ORDER BY tbl_ROHE_IWI_lookup.Order; And I...

Hi Gina - I'm using Access 2010. The code in frmMain that opens up frmDeceased is: Private Sub cmdOpenDeceasedform_Click() Me.Main_SubForm.SourceObject = "frmDeceased" Me.Refresh End Sub Once I am in frmDeceased, the code that I have for populating the Iwi combo with the selection from...

Hello, I have a form named frmMain that contains five buttons that lead to subforms, one of which is named frmDeceased. In frmDeceased, I needed to create a combo box that relied on selections from the combo box before it. With the help of someone on this forum named vbaINet, I was able to do...

Ah, yes - it was the Requery I was missing in my Event Procedure. Thank you - that's what I needed.

Thanks, I was following a very similar example but I still can't get this right. I played around with it a bit more and have gotten it to a stage where the Iwi (tribe) does populate based on the Rohe (location) chosen, but if I then go back to Rohe and choose a different location then the Iwi...

Hello, I can't quite get my code right for populating one combo box based on the selection in another, and I was hoping someone could please take a look. I didn't create this Access database but I've been asked to add in a second combo box that is based on the selection of the first combo box...

Great! Thanks for that.

Thanks Galaxiom. I had written my second comment before your response had appeared. Yes, its bizarre that the checkboxes look so large but I can only assume that the database designer wanted it that way for some reason. The team wants to be able to analyse their results in the future so they're...

Never mind. I tried a few things and changed the Lookup to a Text Box which seems to have produced a better result. Thanks anyway.

Hello! I am not usually an Access user but I have been asked to amend a database. On the form, six checkboxes have been added and when I go to the table these checkboxes appear as large ugly checkboxes that are so enormous that only five records can be viewed on screen at once. I have attached...

They paid an external provider several thousand $ to build it for them but it was full of spelling mistakes and errors. The manager didn't want to look bad in front of her manager so she just asked me to fix it for them. I told them it would have been better to start again from scratch...

Thanks, but while its easy enough for me to copy and paste code, the data entry people can't fix this themselves and I won't be here in a few months so if she does this again she won't have anyone to help her. I have no idea what she pressed to have broken it like this and she can't remember...

Yes, a pop-up box informing "I was clicked" now appears when I click the form button.

I had already tried Trusted Locations. I added in: C:\Users\ashaw\Desktop\ (my desktop location where I temporarily pasted the database to see if I could get it working there) E:\ (where I have back up and current copies on a USB) And of course C: where Access itself is stored along with its...

I tried that, but clicking the arrow only offers me one selection. [Event Procedure] is my only option there. I opened up the previous version (backup) that I'd saved the day before, and following your prior instructions ("Click the elipsis button (...), select Event Procedure and Click ok")...