Search results

I have a variable (dtDueDate as Date) showing as 6/28/2013. I want to append a time value to it (dtMaxTime as Date) which is 5:00 PM so dtDueDate reads 6/28/2013 05:00:00 PM. I have been going in circles trying to figure this out. My goal is to append this date to a table field which has a...

I have a report that has InvoiceLogo (full path to image on network) and logo ID on the reports recordsource. The Image pulls fine for me, but other users are not able to see the image. I have the UNC path stored in the table and have the unbound image controlsource set to InvoiceLogo. Image...

I have pulled the record count from the subreport to the main report, but I can't figure out how and where to place the sort so I can have the largest number of suberport records on top. the sort for that field is greyed out becuase it is dependent on the subreport loading first, i guess...

I have a data range "states" that is dynamic. I want to copy from a separate worksheet and paste another dynamic range "types" 1 row underneath the last row of datarange "states". Since the ranges are connected to Access query info, the data is fluctuating constantly. My guess is that VBA is...

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...

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...

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...

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...

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...

I am really perpplexed with this one. Right now I have 4 separate queries running from one table (counsedetails) that show the status of a request (status) and the date that the status changed [status change date] so I know a count of what claims (claimnumber) has been pending over 5 days, 6-10...