Search results

Hello all! The following code was working, but I was experimenting with some different ideas and decided to go back to my original setup. Unfortunately, the code does not want to cooperate anymore. When it would ask if I want to "Save" and I click "No", then it would clear the data and not...

Hello all, When a user selects a name from a combo box then 11 textboxes are populated with personal information. What I am looking for is when the user edits the persons information (i.e. changes the persons phone number to a different number), how do I update the table with this...

Hi All, I am using Access 2010. I have a form with three listbox. My issue is this, when I go from listbox to listbox the selected item in the previous listbox is still selected. I would like it so when I go to the new listbox, then the previous listbox selection will no longer be...

Hi all, I am hoping that someone will be able to help me with my problem. I have a report that I am trying to show data for the current year, but with a record count. So, for example: I have 3-OVI, 3-Conduct Unbecoming, and 3-Did not transport for the current year. When I run my report, it...

Hi Guys, I have a main form with a suform. The information on the main form is "read only" and the subform is used for data entry. I have a cbo that is used to find personnel and this is located on the main form. When I select personnel with the cbo, this populates the main form fields and...

Ok, I think I may have messed up. We have an older mdb at work that has a mdw as login/security. Well, the guy that setup the database is long gone and we are trying to get in to setup different individuals as admins. Well, I found something on our forums that will let me join the group, but...

Access 2010 With the help of pbaldy, my code is now validating for duplicate entries. My problem is now with the rest of the code: Private Sub RankOrder_BeforeUpdate(Cancel As Integer) Dim lngRankDup As Long lngRankDup = Nz(DLookup("[RankOrder]", "tblTestEvents", "[RankOrder]=" &...

Hello all, Access 2010 I am trying to check for when a user trys to enter a duplicate number. The control that I am checking is in a subform on the main form: Main: frmCandidateInfo Sub: frmTestInfo Control on the subform is: RankOrder I am trying to check the control entry against...

Hello all, I am using Access 2010. I know this has been asked before, but I could not find a solution to my problem. Whenever I come to a record that does not have any data in my subforms, then (as you can expect) my subform controls disappear. My subforms have "Allow Additions" set to...

Hello All, Is it possible to generate a report from 2 listboxes? I have attached a pic of what I am trying to accomplish. I am wanting to have a report open with only the criteria that a user selects from the listboxes. listbox 1: User selects a case number(s) listbox 2: User selects the...

Has anyone used Allen Browne's GoHyperlink? If so, I was wondering if you had an issue with PDF's and Word docx's opening in the background of your Access database and were you able to correct this behavior?

Hello, I have read where you can drag fields onto the tab pages to create a form or you can place a subform onto a tab page, but can you drag an existing form onto a tab page? I have done it and it is working, but I just wanted to know if this is ok to do or would it lead to problems down...

I got his module to work, but I cant find him to show him what I had done. The guys post disappeared. Also, I noticed that another guys private message to me disappeared; was there a reset to the forum or something?

Hello all, I have asked a similar question before and with the help of another member I was able to generate a report using querydefs, but it does not seem to work with my current query. The only difference between my other query and the new one is that the old one used a single source...

Hello all, Yet another question of many to come, lol. I have a listboxA on formA and a listboxB on formB. When the user clicks an item in listboxA and then presses the view record I want formB to open and the item selected in listboxA should select the same record in listboxB. This is the...

Hello All, I have a quesiton: I have in place an error handler that traps the Runtime error 429 and resumes with the rest of the code; by trapping the error , will it overtime corrupt my database? Thanks!

Hello all, I am trying to populate a word document from a listbox selection. The word docx populates just fine with a form (Rowsource is a query) and the code below in the click event of the button. What I would like to happen, is when the user selects a record from the listbox and then...

Hello all, I have a few auto populated forms (Word docx) and was wondering where you guys store your forms? Do you just keep them in the documents folder on your computer or do you store them in a table within Access? Thanks!

Hello all, I am running a query that is used to show a count of certain values. For example: The number of different Allegations. The values would be grouped and counted: Damage Claim 3 DUI 2 and so on. This works as it should in the query, but I noticed that the query...

Hello All, Is there a way to use the "AND" operator in an IIf statement? I have two statements that need to run in the control source of a control. IIf(DateDiff('d',[LDStartDate],Date())>=366,"*","") Checks to see if the LD Start Date is over a year old. ,IIf(IsNull([LDEndDate],"*","")...