Search results

how would you take a form created in access 2007 and email it to someone using Outlook 2010 so that the person receiving the form can fill it out and send it back and then have the data imported into a table in access 2007? Thanks.

I have a treeview that when I click on one of the nodes the event is not firing. Actually, nothing happens. I don't have a clue as to where to start. I am using Access 2010. Last time I worked with it everything worked fine. Now it has been released to the public and now I have the problem...

I have an Access 2010 database that uses a login form that has a button that direct the user to another form. When I click on the button code is executed and I get the error "The OpenForm action was conceled." I followed the execution to a utility that is called during the opening of the...

I know that this should be very elementary but I can't get it. I need to combine two fields, first name and last name, into one field. How do I do this? I have tried fname + " " + lname and fname & " " & lname. Neither one works. Thanks.

I am not an Access programmer but I have been asked to make some changes to an Access DB. I need to open a Word template and populate some bookmarks on the template. I have found code to open the template but I can't get it to open. I get the error: "Type mismatch". Here is the code...

I have been given the task of reinstating a subroutine that had been removed in the past. The actual subroutine was deleted but the call to the subroutine was commented out. Now, I have rewritten the subroutine but can't get it to run because when the process gets to the subroutine it throws...

I have an old access 2003 db (windows XP) that I am converting to access 2010 (windows 7). In the frontend I have a connection to an old SQL Server 2000 database. I need to recreate the connection from the access 2010 to the SQL 2000 server. Here is my connection string...

I have a UNION query that I pass two parameters to but those two parameters are used in both sides of the union. SELECT bill.TripDate AS Bill_TripDate, bill.voucher_nbr AS Bill_Voucher, bill.fare AS Bill_Fare, tbl_from_xl.TripDate AS XL_TripDate, tbl_from_xl.voucher_nbr AS XL_Voucher...

I have two queries that I use a UNION to combine the results. However, I am losing records from the top query. Why? If I run the top query alone I get all the records expected. Here is the query: SELECT bill.TripDate AS Bill_TripDate, bill.voucher_nbr AS Bill_Voucher, bill.fare AS...

I have not worked in Access for a while and now I have been tasked with writing some queries in Access 2000. Here is my simple query: SELECT tbl_from_bill.TripDate, tbl_from_bill.voucher_nbr, tbl_from_bill.fare FROM tbl_from_bill AS bill, tbl_from_xl AS xl WHERE (((bill.voucher_nbr)<>...