Search results

I have a program that exports repeating items on one row and I want to rearrange the data to use it in a report. I need to take data such as(where '*' denotes no data): ID_____Item1_____Name1_____Item2_____Name2_____Item3_____Name3...

This may sound dumb but check to see if under the button's click event " [Event Procedure]" is listed. There have been times when I accidentally deleted this which would cause nothing to happen when button clicked but would not delete code. If it is there then put a breaking point to make...

Is there no one who knows the answer to this?

Whoops, I thought I had already posted a reply. I'm using the conditional formatting in design view.

I have a subform on a tab control. I want to add a text box that will be unseen by the user when there are records in the subform but visible when there are no records displaying "No Records Found". I want to do this by using Conditional formatting by having formatting blend into the page...

Thanks for the suggestions. A list box won't work very well because of space issues but I think I'm just going to show the second column to indicate which ones are checked. I was hoping for something a little more stylish but this other way will work fine.

Is it possible to highlight rows of a combobox based on a hidden boolean value in the second column? I've tried using the code [combobox].column(1)=1 under conditional formatting with no luck. I'm including a photoshoped image of what I want.

Word of caution on the video. When requering the form it will look for all matches to the pattern created by "Like forms![frmName].[control] & "*"" If you have an autonumber for your index with numbers ranging from 1 to 110 and the combo box is looking for record 1 then you will get several...

OK, found a solution OK, some of the functions used with the UNC and Internet servers were the same so I thought I would reuse them for both. The problem I ran into was caused by this or rather my lack of understanding of how the functions worked. My quick and dirty solution was to make two...

Ok I've got something that is working. I had to add a reference to MSWINSCK.OCX to use the winsock activeX control. I'm having an issue though when I try to sync via internet servers. When I click the sync button under the internet section it messes up my system clock even though it returns a...

I have two questions the first is code related and the other is design. 1st: I need a way to sync up to a trusted external time source such as time.nist.gov via VBA code. 2nd: Since I'm looking to develop an audit trail I need a way to get time and date that cannot be tampered with by the...

You've set the RowSource but you need to requery it. such as: Me.cboCUST.Requery Me.cboCUST = Me.cboCUST.ItemData(0)

I'm developing an audit trail using some code and ideas from ghudson's audit trail. I'm having all changes, new records, and deletes saved in a table. The issue I'm running into is capturing deleted field in my tables that have relationships with parent tables. I have included a sample...

Link not working Link not showing any results.

Problem Solved The user was part of a Workgroup that was saved on his computer but not the System.mdw file. There are only two databases in access that he was using (neither one secure). Since there was no need of the security file I had him Join back to the System.mdw file. Everything is...

I have a DB with a DB password. I have not implemented user level security in my database but one of my users tries to open the database and is prompted for a username and password. He is part of a workgroup for another database though and I believe that may be what is causing this issue. I...

Same problem with a diff twist. I'm trying to look for date values. Long Explanation: I have an option box that allows you to pick "All","Open","Closed" which resolve to the criterias I want in my query which are Blank, Is Null, and Is Not Null respectively. This is saved in a textbox called...

I have several subreports inside a report to achieve a specific report look. I've notice that my count on the report works fine but the "Max Grade" will show more than one value if it finds different values for Grade. In the example report in the database you can see that for "Ear, nose, and...

Ok working. I used the new Between syntax you provided to come up with this: Between Nz([Forms]![frmReportParameters]![BeginDate],#1/1/1900#) And Nz([Forms]![frmReportParameters]![EndDate],Now()) I placed this in the criteria for my date and it seems to be working great. Thanks for the help Wazz.

I have Categories, Event, Number reported, and Max Grade. I want the report to look like the image I've attached. The Max Grade is a number from 1-5 that is recorded for each of the Events. Grouping allows me to get these numbers but I'm not sure about presentation.