Search results for query: *

Yes, you two are right. I'll stop being stubborn and go the U-Tube route. After all, I do like those X-mas Cards. Thanks, Dan

Well, because I don't want to do that. I am not out for the $$ or notoriety or anything and that is what works for me. This is more of a family thing. I don't do FB either. Not my style. I think I need to do some sort of me.refresh or me.requery after or while the page is loading to have...

Hi, I have done something similar in the past by periodically exporting tables to an external database based on user criteria. In my case, it was several tables on a weekly basis. The customer could copy out the exported tables anytime he liked, and it preserved the integrity of the original...

Hi, I have two .wmv files embedded in a web page (I use Firefox) using this simple code: <object data="images/howl2.wmv" type="audio/x-ms-wmv" height="240" width="320"><param name="FileName" value="images/howl2.wmv"><param name="AutoStart" value="0"><object data="images/howl2.wmv"...

=DLookUp("sum(Given-Nz([Sold],0))","Product Query","[EmployeeID] = [Reports]![Invoice Old]![EmployeeID] And [SKU] = [Reports]![Invoice Old]![SKU] And [dateSold] between me.txtStartDate and me.txtEndDate") Something similar to the above should work.

I'd opt for a workaround. Some things better done in Excel. You can start Excel from Access... Private Sub Form_Load() On Error GoTo Err_frmError Dim stLink As String Dim ctl As CommandButton stLink = "E:\BPCT\BPCTCharts.xlsm" Set ctl = Me!cmdOpen With ctl...

Here's a couple things that come to mind although I didn't check them: You could set the subform to add new records only. You could set the recordsource of the subform to autonumber (if you have one)descending. One of those might work.

The following is probably along the lines of what you are looking for. A login form contains a combo box which lists out names. An After Update event of the combo box turns a password text box visible. The user supplies a password. If the password matches the password stored in the table...

It's pretty easy to do this in a query: TrimAddress: Right([address],(Len([address])-1)) Hope that helps

Hi, I don't know that you can change the dialog box path but if you are dealing with many files in many directories, it might be easier to build the hyperlink strings yourself. As an example you can obtain the file names and directory paths using FSO and store the text strings in a table...

If you have the chart in a report, go to design view and double-click on the chart and you should be presented with formatting options up top. Right-Click on an item in the chart area to format a specific object. Size the report by dragging the chart.

Sometimes all you need to do is force a refresh on your chart: In Detail Format of your report: Dim objChart As Object Dim objGraphApp As Object Set objChart = Me.YourChartName.Object Set objGraphApp = objChart.Application objGraphApp.Update objChart.Refresh

Yes, I have seen that handy resource but it doesn't answer the basic question (to me) about what exactly a basic doctype is. There seem to be about a half dozen of them and their definition seems to based on validation service they use which means to me - six of one, half a dozen of the other...

I have to admit ignorance here. I don't quite know what you mean. I looked it up and if it means include the type of validation with the doc type - the verification URL, every one I tried gave me more errors than what I currently have. Interestingly, if I used the transitional URL then I got...

Well, I got it hooked in and it works very well and of course this is giving me a couple other ideas that I can probably figure out on my own now: www.ddgnevada.com I do learn my lessons and I ran the web page validator thing and came up with this: Validation Output: 1 Error 1. Error...

That is a work of art. Thank You. It works beautifully. Unfortunately I am traveling so I won't get to work on this for a few days but when I do, I will ensure the proper credits are included. Awesome job and worth more than just one star. Thanks again for all your help, Dan

Ok, I fixed the validation errors (should have paid attention to the 'Make sure your web page' message) and it passes validation. When I run it only the owl pops up in IE and FF. In IE the logo flickers very briefly. Maybe I need to increase the seconds for fading?

Yes, got in a bit of a hurry this morning.

Ok, I fixed that and then did a side by side comparison of the original and darned if I can see anything different. The page load goes directly to the picture and skips the logo. This all started when one of my kids said he thought my index page looked rather cheesy and it needed a logo. I...

Hi Jeff, thanks for the reply and the help. I loaded the new code and it seems to skip the logo and goes directly to the picture with no cross fading. I flipped the pictures and renamed them to ensure I got that right with the same results. I thought maybe to body onload tag needed something...