Search results

I just wanted to update this and get some more opinions on why I would still be getting an error. Here is the code I'm currently using: Private Sub BandNum_AfterUpdate() With Me .RecordsetClone.FindFirst "[BandNum]= '" & Me.BandNum & "'" If Not Me.NoMatch Then 'Verify if...

Hello, I am managing a Microsoft access database that holds records for different species of animals and such. I am very interested in the web apps for Microsoft Access and after looking into it still have some questions. Am I able to quickly use the forms already created and post them on a...

Hello there and thanks again for helping. Here is what I have now (I added a period). When I type a number in every time (if its a new number or duplicate number) it highlights the first private line and still says compile error: Method or data member not found. Could it be something to do with...

Hi madefemere and thanks for taking the time to help me with the code to do this. I am taking a class next week on VBA code so hopefully I will be learning alot. My numeric field is called BandNum and my checkbox is called Recapture. Its throwing me a error stating a Compile error: Method or...

Hello, my question is in regards to a access 2007 database. I am trying to figure out the code to try to do 2 things in a form. 1. Prompt a error message when a duplicate number field comes up, (this is not a primary key but rather a stored number ID, number field) saying something like this...

One more question. When using this code: Private Sub MinusButton_Click() Screen.PreviousControl = Screen.PreviousControl - 1 End Sub Private Sub PlusButton_Click() Screen.PreviousControl = Screen.PreviousControl + 1 End Sub When I am selecting a cell and am using the plus button and and then...

Just to finalize it for others to see the full code snippet that works is as follows: Private Sub PlusButton_Click() Screen.PreviousControl = Screen.PreviousControl + 1 End Sub You could do a minus button with the opposite: Private Sub MinusButton_Click() Screen.PreviousControl =...

Thanks guys, I guess I'm not sure how I could implement either of those. If I use spin buttons can I use 1 set of buttons to do an entire form? If so what would the code look like? Would it reference the form? And I tried the code PreviousControl and it didn't work. However I don't think that...

Hello all, I'm working on a form that I want to insert a plus button/minus button.I am aware of the vba code numbers 107 and 109 if you want to use the actual keys but I would rather use a button. I made a button and here is the code I used now. This code is numeric box specific. So it only...

Hi all, I was wondering how many user could enter data on the same form at a single time if its on a server (and they are on the database on different computers). I thought Microsoft access could handle multiple people and number then accordingly and keep them separate, right? Is there anything...

I'm new to VBA but am starting to get this however this doesn't make sense to me. What does it mean to stamp the user ID on the record? And would the user ID be different than just the users name (initials)? A little more explanation would greatly help thanks so much. :banghead: Private...

Hello all, I am trying to set up a password on a for different users to have to enter pins to enter data. When a user selects his/her name from the combo box the next field will be something like pin. When they enter the corresponding pin this will allow them to edit and start or continue (if...

Sorry I'm kind of getting more confused from this. How about this does anyone have a sample database that I could download and look at with a setup that address the question that I asked? Thanks again all!

Hi I am trying to get a form to search a date range (so this is also kind of both a form and query question). I would like it to look sort of like this build. I use 2007 access. Something saying Specific Date: __/__/____ Calendar button here Check Box Here Ending Date:__/__/____ Calendar...

Hi all, I need to create a report with multiple subforms and I cannot figure out how to do this. I set up my first report and then I believe I need to add "more detail" sections or another page to this report so i can drag in my additional forms. How do i separate out sub forms? Ideally I will...

Hi all, I am trying to link two unrelated sub forms to a main form so I am able to query data all at once and make a report that displays all this data at once. I do not know if this is possible. I will tell you to the best of my ability about what I have going on. My main form is a shift...

Hi all, I am a inexperienced Access user with big ideas and goals. I am currently working on a project now and I have utilized this site and realized I needed to join up! Hope to talk to you all soon, rlangford.