Search results

Actually that's the only field name I edited, but to your broader point, I suppose you'd just have to take my word for it. I am willing to post a stripped down version of the database if it would help?

Thank you for the responses. CJ, the field is actually not "Date", it's "DateOfSomething". Made some edits prior to posting for privacy reasons. I tried switching to an inner join and when I do so, it says I will update 0 records, but gives me no validation rule violation. FYI, I am not too...

Hello, I have a split database where I distribute front end copies for people to add their records locally and then append them to the back end tables. I also have given them the capability to modify the back end records that they have appended via update queries. Does anyone know why my...

Nevermind, I combined your two suggestions and put that code snippet into the On Open event of a form. Thanks again to both of you.

Thank you both. arnelgp, I am pretty new to coding. I have some simple code in my forms tied to buttons, after-update, etc. But I am unsure if you mean something different by a "public" function. Do I use "Insert Module" for this and put the code you wrote there? Or somewhere else?

Hi, Is there a way to have Access run a query automatically when the database is opened? Background: we have a shared split database that we'd like to give users the capability to work off-network with. There are tables in the back end with employee numbers and such that will be updated from...

Hello, Upon opening my database, the user makes a choice as to what two items he/she would like to open. After choosing and using the button, the two forms open as two separate subforms ("FormA" and "FormB") in a main form "Form1." These two forms are linked to different tables and I would...

Just what I needed. Thanks!

Hello, Using this code I found elsewhere to open up a word document using a button on a form: Private Sub ButtonAK_Click() Dim APDKey As String Dim App As Object APDKey = "C:\Desktop\AK\2014.doc" If Dir(APDKey) = "" Then MsgBox "Document not found."...

That does help very much. Thanks for the explanation!

Maybe I'm misunderstanding something on a fundamental level. For example, I make a form with three combo boxes on it, and tie them to a respective field in a table (and form's record source is said table). But when I look at the properties of these three fields in the table, all three may be...

Hello, I have a form full of combo boxes tied to fields in a table that work perfectly fine. However, I noticed that when going into the tables and looking at the "Lookup" tab, many of the fields tied to combo boxes on the forms have the Text Box property instead of Combo Box. I've tried...

First, thank you CJ - apparently I did need two setfocus lines. Galaxiom, I think I agree with using KeyDown, but I am having the same problem as the gentleman from the post below, except I'm not sure how to solve it as he did...

I am trying it just to test it and it's not giving me an error, but it's not working either...it just goes back to the first field of the first subform. Private Sub TextComments_LostFocus() Parent.FormB.Form.TextReg1.SetFocus End Sub TextComments is the last field on Subform 1, TextReg1...

Galaxiom or anyone else, can you help with tab order? I need the user to be able to tab from the last field of one form to the first field of the second. I am familiar with using setfocus, but unsure how to apply that when the two form names can be different each time depending on user choice.

Thank you very much for the demo. This is great. Much appreciated Galaxiom.

I really have no idea how to even begin doing that (Access noob). Can you give me a link to read up on it or give me some tips?

Very well, I'll look into other options then. Thank you.

Because the user will have about 10 different choices for frmX and 17 different choices for frmY. Wouldn't that mean that I would have to make 170 of them? (Yes, it is quite possibly not designed ideally, but the company is beyond that point)

I will try. Two different forms pop up for data entry after the button is used. So two windows open, one with frmX and one with frmY. I would like both of those forms to open in one window. Is this possible? I considered the subform idea, but it would be much more work. So before I went that...