Search results

thx much..worx great

I am trying to convert a whole number to a start time w/ no luck. Assuming "0" is 12:00 AM, I have a start minute of "480" which would in essence be 8:00 AM. Can anyone tell me if I can somehow convert this to time in my query? Thanks.

I have 2 Data Access Pages that are almost the same. They both pull data from my dB. The issue is that when I open one of the pages it works fine the dropdown list has all the things in it that it should, but when I open the other DAP the dropdown list is blank. What could cause this to happen...

Well one thing you could try is make subreports for each memo field and set a page break before them and then one after them. That would keep all the memo fields on one page IF they dont fill the page then it would break to the next page for anything that followed.

Thank you Rich..you are right. I was just following the post hehe.

Or convert your original date time to a "second start" using 0 as midnight.

Im not sure if you can do it that way or not but do all my page breaks there but you can set a page break w/ the Page Break clicky in the toolbar as well.

cant you set this in the Sorting and Grouping area and set it to Whole Group?

The difference as in the number of days difference? Like a text box that has this =Iif(Not IsNull([date sent]),[date open]-[date sent],[date open]-Now()) is that what your looking for?

I have a report that has 2 subreports in it. In order for the subreports to run you have to enter a date range that come from the query. Is there a way that I can set an [Event Procedure] so that it sets the date range the same for both subreports? Something like this..this doesnt work but...

can we see the code?

I use Access to open a workbook from a Simple Form. What I want to know is can I add code or a macro of some kind that will select Range("A:A") and Delete that column after the workbook is opened w/ the Command Button in Access. This is kinda an extension of a problem I had earlier... Here is...

Got It! ...NM

I am trying to open a workbook with a command button on a form however the path to the file is giving me a fit. The path for the file location contains spaces and I am going blind trying to figure out how to rectify the path. Heres the line. I am sure someone here will see this problem quick...

OK I tried something different. I removed the dropdown from the page and just set it to show all data..guess what? Its still blank. I thought it may have just been the dropdown. All that shows on the page is the Header fields.

No..Heres what seems to be the issue.. We are thinking it has to be some browser setting or something. Reason is because there are only about a handfull of people that cant see the data in the drop down. I am not sure if its an activex setting or what. We compared all of the Internet Options...

Still no luck. This is getting frustrating...I think ive tried every setting trying to get this drop down to populate.

I have a DAP that many users have access to.When opened the Dropdown is blank on some peoples and populated on others. Is there some setting that can cause this. I have checked to make sure that they have the allow ActiveX Controls to run files on this computer checked. Any other setting that...