Type: Posts; User: johnhutchison; Keyword(s):
Thanks for posting your solution. It looks interesting. I did not know how to do it.
When it uses Resolve to check its status what is it looking for? What sorts of thing is it finding that your...
For me checkboxes in 2010 behave just as they did in 2003, but always use the mdb format rather than the newer accdb.
Does it help if you remove the checkbox from the layout? Switch to Design...
In Access simple arithmetic on dates works OK (e.g. Date()-30) but I believe that this is not true with SQL Server.
I only every work with Access so I usually just use the arithmetic method, but I...
Yes..you still open the filtered report (as RG said to do) but only in Preview Mode, then use the Docmd.SendObject while the report is open in Preview Mode, then Close it and move to the next record....
Further to RG's response, in Access 2010 you can remove all references to Outlook, and creating the PDF and just use code like this, assuming you have defined the variables, and assigned values to...
Do you use Zone Alarm Firewall?
I found this thread which might help.
The Syntax for DSUM is:DSum(Expr, Domain, Criteria)
Paid: DSum("Amount","KYOWAPayment","[Wire Date]<=#" & [Received] & "#")
But what is Received? Is that a field in the table KYOWAPayment ?...
To be able to Search for one city OR another you need two text boxes.
The SQL for the query looks like this:
The short explanation is that you just can't use form controls as parameters in queries used by DAO. DAO operates at a lower level and does not know about Access forms.
So generally the solution...
I just want to make sure I am clear about this.
Your form has a number of controls on it. If you fill them all in, the query which uses them all as criteria works.
But you want to be able to...
Does your export code use DAO?
Have you explicitly declared the parameters in the query Parameters Dialog?
You don't always need to do this, but if things are not working in can help.
The syntax you need is:
This code executes from form1, so Me is just a reference to the form the code executes from.
But does the record in table2 exist? Or do...
If the query parameter came from a form rather than a query prompt then you could include it in the file name automatically, rather than having to use an Input box to ask for it again.
The SQL used for rsRen is based on some SQL that joins a whole pile of fields. When you join tables a record is normally returned only if there is a match on both sides of the join. It seems that...
You move back to the first record each time you go through the loop.
You don't need the .movelast and .movefirst within the Do Loop.
The Dim strOldNote as string line should occur before the loop...
I am not aware of anything changing with this from 2003. I still just use an AutoKeys macro like I used to. (But I never use accdb format. Does that affect things?)
I think you are right Patt.
I agree that a text field is the right solution.
But Nancy has said: "My problem is that we have the account number field everywhere in multiple databases, tables, queries and reports. It is a key...
You are correct about CurrentUser.
Here is another function that does what you want.
Public Function NetUser() As String
Dim strName As String
Dim strUserName As String
I usually rename the file and/or move it to another folder rather than just delete it. But I agree that just leaving the file there is an invitation to import it again.
If you look on the Property Sheet, at the properties of the form itself, on the Data tab, there are properties that control just this.
I would think that you don't want users to create new records...
If properly rewritten it could handle multiple files and import them.
Here is a version that works (I think).
Private Sub cmdImportexcel_Click()
Dim i As Integer
Dim zXLFPath As...
You are right that changing to AllowMultiselect=true allows you to select multiple files, but
PickFileDialog = .SelectedItems(1) takes the first of the selected files and returns it.
The code tries to deal with this by having the FileDialog return Exit if you click Cancel.
If .Show = True Then
cmdFileDialog = .SelectedItems(1)