Hello Experts,
I am trying to create a copy button for users to click if they want to copy a forms fields and connected subforms fields to a new recordset. The Subforms involved have a 1 t...
Experts, I have the following code and need to modify it to allow for a null (or a no date) in the [DateOfIssue]:
How do I modify the below? I included all the code so sorry so long. Th...
Hi,
I have an access macro coding but in that the EXCEL.EXE process is not ending when the xl.Quit is run
Please fix the error....
Thanks,
akiles
Experts,
Is there way I could write a utility (probably in VB6) that would look through all of my data tables and erase all of the content in each one? This would probably also require the...
Hello,
I'm wondering if you can code a macro (VB) in Outlook to populate the subject line of a message based on the filename of an attachment? Essentially I have a report that gets mailed ...
Hi,
Since i'm new to VB i try a little code .Please advice on it.
I have two tables in access db.
table1 t1
id
name
city
table2 t2
id
name
Now i want to write a macro so...
Trying to convert or use an Access 2003 application under Access 2007.
Conversion from mdb to accdb file did not seem to be problematic. Discovered, however, that there was a "new bug". Appli...
Seeing that Access doesn't do letters well I've decided to do a mail merger in Word from my access db. I want to basically create a recordset and call some code to run the mail merge in word....
Is there a way to execute a query like below on another access database in VBA.?? I want to run the sql on another database.
Thanks
Andrew
Hi Experts,
From a table, I need to extract a person's initials and populate the results in a new field. Currently, data about a person's name is seperated into two fields. Eg FirstName and...
Hi,
I have a combobox on an Access form named cboJobType. Its row source is: "Mail";"Print";"Other". I have the following query run via a button click event when a value from cboJobType is ch...
I am importing a table one of the fields is coming in as "text" in excel and causes a problem with the relationships.
How can i change this field automatially when it comes in using VBA?
I...
Hi,
I've created a query, and have added a couple of parameters in it, but how do I use these parameters in the criteria field? Also, when I call the query from code (DoCmd.OpenQuery), how ...
Dear Experts,
I'm using a textbox which the user can populate to filter a listbox with records.
I want to refresh the listbox after each character the user enters in the textbox.
I trie...
How can I parse out a name like this:
SMITH,JR,JOHN,R
amobg records that have this:
SMITH,JOAN,A
Any ideas?
What is the relation between vb and ms access ?
I am not sure if I will have to use a query for this or not, really just look for the best way to go about this. I have 2 tables (table1, table2). Each table contains an Item column and Scan...
I've done this a million times before but for some reason it is not working for the way this query is structured.
I have a To and From Date on a form that i'm trying to pull to run the quer...
My Access app has an email facility but I can only enter plain text in the body. I would like to invoke an editor with basic formating; Font, Bold, bullets etc. and store it in a memo field ...
The original table looks like this.
name1,classa, houra, teachera
name1, classb, hourb, teacherb
name1, classc, hourc, teacherc
name2, classa, houra, teachera
name2, classb, hourb, teac...
I have a Access Database. It is open so that users can edit tables. (They open tables from the database window. (I know an interface would be better, but they requested it be this way.))
Ho...
Morning
I posted here recently a question about totals query which Boag2000 kindly answered. However the requirments for this have now changed! no suprise there!
What i wasnt to do is ...
I have the following code on my report. I have created a line (named Line99). I have placed the line in the detail section. Visible of line99 is Yes.
So, for this test I want to just turn ...
In access 2007 it is possible to very easy save an attachment
but how can you print that attachment (pdf) , have heard that pdf is intregrated in access 2007
can't seem to find anything ...
I 'd like to upgrade an Access2003 application into Access 2007.
In Access 2003, there are some FMS Memo Controls and associated memo fields in the database.
I replaced FMS Memo controls wit...
