Recent content by pdldavis

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