Search results

Hi, I have a form with four pages and subforms on each page. I am having issues with scrolling on pages 2-4. The first page will scroll correctly (to the bottom of the form), but the other pages will not scroll at all. I did enable the scroll bars on the subforms, but they will only scroll to...

Hi, I have been developing a database for my group, which they will be using mainly for data entry. Most of them have never used Access before and are nervous about switching over from Excel. I'm nervous about the behavioral shift that needs to happen and how to guide people through this...

Hi JHB, Thanks for the reply! I tried the "Oncurrent event" and it worked! I tend to make things more complicated than they need to be. A lot of what I do ends up like a Rube Goldberg machine! Thanks again!

Hi, I have a form based off a query that pulls information when inputting an ID. For example, user clicks the form, then a pop-up box (from the query) occurs, then after adding ID, the form with populated data appears. However, I would like to change some control properties on the form...

Hi pbaldy, Unfortunately, I don't feel comfortable uploading the database, but I will look at DoEvents and play around with the code a bit more. I really appreciate your help! All the best!

Hi pbaldy, Thanks again for your help and I apologize for the delay in my response! I tried both of your suggested methods. I still have the same problem when removing the quotation marks. For your second suggestion, the Boolean code, when I run the code I receive a Run Time 94 error. I tried...

Hi pbaldy, Thanks for your reply! I tried referencing the other form in the following code: Private Sub ID_AfterUpdate() DoCmd.OpenForm "Culture_PFGE_Form", acNormal, , , , acHidden If Forms!Culture_PFGE_Form!culture_interp = "1" Then Me.mlst_date.Enabled = True...

Hi, I am trying to disable a field in a form based on a value in a field on a different table/form. I have been able, through simple VBA code, to disable fields based on a value in the same form. Is there VBA code to do this? If so, could you please give me an example? Or are queries/sub forms...