Search results

Your doing this: Forms!frmHome!frmDataSource.Form!frmDay1.Requery You need to be doing this: Forms!frmHome!frmDataSource.Form!frmDay1.Form.Requery In the first version, you are attempting to require a subform CONTROL. This is the object that houses the subform, and it cannot be requeried...

Unrecognized database format. I'm using 2007. But I showed you how to do it in my last post. You should always develop in the 2000 format to avoid issues like this. I only upconvert to the 2003 mdb version to make the mde. I don't use accdb at all. Microsoft was stupid for not changing the...

I suppose it should have been more like this: Forms!Form1.[Table1 subform].Form.[Table2 Subform].Form.Requery Here is an example. Open Form1 and Form2 and Table2. Add a new record to table2. Close the table, then click the button and the requery works.

Hmm...if you post a stripped down version I will get it for you.

Are frmDataSource and frmDay1 the name of the forms or the form's subform control?

I don't know about that but Microsoft has free software called Sync Toy. It works quite well.

You are referencing the subform incorrectly. First of all, it helps to understand the difference between ! (bang) and . (dot). The ! means you are talking about a field while a . means you are talking about method or property of an object. I'm sure someone will correct me on this though...

The inside width is 8568, which is slightly smaller than using the width of the subform control, so the result is about the same. I think the issue is that I can't tell the size of the subform once the anchoring is applied. edit- I think I got it now. Using inside width on the resize event...

I have a datasheet subform anchored to the bottom right. I want the columns in it to stretch across the whole subform. Am I able to do this? The line that is printed is: 8580 8579 but there is still plenty of room left in the subform. Private Sub Form_Load() Me.MissionID.ColumnHidden =...

So I am home now and I can duplicate the network at work. How do you propose testing the form? Also, is there a way to fill tables with dates, times, and lorem ipsum text to generate thousands of records? At work, the data was imported from other sources and goes back to 2000, so there are...

Have you ever modified the database in a newer version of access? Can you try to open it in 2013?

Did you try importing the objects into a new database one item at a time? It is probably just one form that is giving you trouble.

Is it proper? Define proper. It is great for some things. I would say it is great for small businesses, for rapid solutions, and to teach people how to code. Outside of this, other solutions are probably better.

Wow, it does! MyShortcut.TargetPath = chr(34) & "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE" & chr(34) & " " & chr(34) & "\\officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb" & chr(34) & " /cmd 2"

It looks cool. So you made me question myself, and according to this site, 10 performs better than 7. Thats a pretty good reason.

Here is some reading material. http://www.access-programmers.co.uk/forums/showthread.php?t=219605 I searched MS Access use digital signature.

I will go from 7 to 10, maybe not right away, but I'm ready for a fresh install anyway. My laptop has been a little sluggish lately. I'm a huge 7 fan, and if I don't like 10, I have the install disk for 7 still. I dual booted 7 and Linux for a while, but I didn't like Linux.

MyShortcut.TargetPath = chr(34) & "C:\Program Files (x86)\Microsoft Office\Office14\MSACCESS.EXE \\officeblrgrp2.office.adroot.bmogc.net\Int_Tech\Technology Resource Repository BE\Intake Test.mdb /cmd 2" & chr(34) I would think it would be like this.

Is there an activex control for pdfs? Can you open the pdf inside of an Access form? I can't explore it on this computer. For the digital signature part, are you just using a pin, or are you using a token, like a digital card reader? If you are, then I think it works the same as the PKI system...

chr(34) is the ASCII code for double quotes. You can also use """ to do the same thing.