Search results

I have the combo box setup fine, but I want to have a message pop when the box is null or has no numbers. Additionally, I want to have that "Item Not in list" message to disappear and have it replaced by my msgbox and then have the combo box reset to the first number in the list. Here is the...

You may want to think about splitting the database to a front-end and back-end structure. WHere the datatables are housed separately from the forms and queries, that way you can make the modifications needed without having to open the database exclusively.

This is a great forum to find answers to your questions. I have found the help to be accurate and responses pretty quick. Fro the reponses that aren't so quick, it gives me time to really wrap my head around the issue at hand and develope and implement my own solution. Good Luck!

I don't know if you have already gotten the answer to your question, but it is quite simple. In the table tblHours, add EmpID and create a one to many with tblEmployee (with tblemployee.idEmpTbl There is the junction. Hope this helps!

Welcome! Hope you find the answers you are looking for!

Figured it out. I created an update query and joined the query that housed the data that needed to be update orgcouselfullname which had the ID and joined with counseldetails.name. ran the update and BAM it worked for all records, a real timesaver!

Great, I am glad that it worked out. If you can, please add to my rep by clicking on the scales above. ;)

Counseldetails has an ID(PK) and then has a field [couseldetails].[office originating] one to many to [office origination lookup].[ID] [Office Origination Lookup] has ID and [office]. Cousel Originating has a one to many relationship to [office ogination] again on ID. (one[cousel...

Found this in searching, it may help a bit: http://www.access-programmers.co.uk/forums/showthread.php?t=166014

Okay, I am a noob and I setup my table wrong and now I am trying to get the structure and data normalized. Here is the problem: I have a table [counsel originating] that has 4 fileds: ID (PK), First, last, and Office(Lookup to [OfficeLookup] table. I have another table [counseldetails] that...

Ok, so I made a BIG GOOF! I was updating some tables and one of the fields that was a mutivalue field now has no data. I did make a complete backup before I made the change (thank goodness), but I can't figure out how to update the data back in to the table (Multi to Multi). Any...

thanks for the guidance!! here is the code that worked in the forms OnCurrnet event: Me.Text108 = DLookup("CurrentBudget", "currentbudgetforform", "ID =" & Me.ID)

thanks linq! Where do I put the code? (the ID is numeric) and is the code changed if I want the requestID from the form instead of the table? (I think forms!counseldetails.requestID or something like that). It almost makes sense to put the code in the OnCurrnet Event so I can cycle through...

I am sorry, I may be a bit more noob than I thought. I didn't quite uderstand what you are saying above. I would really rather not redesign my form to pull from a query rather than the table (counseldetails). If you can please guide me to figure this one out, I would really appreciate it...

I am going to try and explian this the best way I know how: I have a form based on a table [counseldetails] and I would like to place the results of a matematical query ((budget + budget adjustments) = currnetbudget) only when the requestID of the counseldetals table matches the requestID of...

I have a form that cotains an OLE object control and I want to be able to drag and drop an email from Outlook to the form. I am able to do it now, but the email has to be dragged to the users desktop, then to the form, then deleted off the desktop so there is no error msg when the OLE is...

Figured it out. I set the Order By On Load to "No" and that did the trick. :)

I have a Query Form that I want to have the user sort by clicking on the sort button in the access ribbon. Then, I want to programically remove the sort on the OnClose event of the form. I have tried Me.frmtester.Form.OrderBy = "" Me.frmtester.Form.OrderByOn = False But that didn't work...

That was easy! thanks!

I have a buch of code in the BeforeUpdate event of a form that I want NOT to run if a control is true [precrg] = true. I know this should be very simple, but the answer eludes me. Please help! code is below: Private Sub Form_BeforeUpdate(Cancel As Integer) If IsNull(CounselID) = False And...