Search results

Hi everyone, I have been looking to create a form to email a query list, this works well but I have been asked to add an extra feature. A frame with option buttons providing from a list of 5 options and the sender wants to be able to select which one to be included. The list is positions...

Hi everyone, I have written code to email contents from a form to Outlook but I am having difficulty in formatting the body of the email for line of code which picks the contents up from a textbox. Like an item that has to be highlighted. Textbox content in the email should be emailed...

Hi All, It has been sometime since I have had to look at Access VBA. What I am asking is can someone look at the following code and correct it please. I have inherited an old database with a new field to add some new invoice numbers and increment the number to each recordset by + 1. Starting...

Hi I have a very large document with 3 headings styles. In the document the Heading Styles have been created to include certain text and styles, the business has now decided they want to change the styles. Is there some VBA that would help do this quickly. Any suggestions would be very...

HI folks, its been a while since I have either posted for a solution or answered other threads. I have an issue which I hope someone can help me with. I have a table tblstaff1 and a forom frmStaff1, on the form I am showing the records in a continous form with 2 combos, what I am looking to...

When I setup my pc I accidentally miss spelled my name and I am wondering if I can change this? My PC Shows the Name Trevwor G rather than Trevor G

I am trying to get around creating an Append Query by using the Insert Statement in a VBA module. This is the Query SQL that I have when I create the query in design view. And this is what I am trying to convert it to using VBA. This is all part of multiple applications being used, so...

Could anyone advise me of a site on how to program an Outlook Design Form in 2007. I am selecting to Design Form. I am aiming to use Combo Box and want to Fill it with Data. In Excel VBA I could design a userform and then refer to the Combo Box behind the form such as:

I am building a query from form controls, where a user will select something from a list box and then also check boxes. What I am struggling with is that I also need to make sure they always get last years selected data. I have been testing some sample VBA to write the Where statement and it...

I am trying to convert a query SQL code to use in a Module to run through VBA but I am encountering an issue with Where statement. what I have in the Query is indicated below: Trying to use this in a module as follows: When I run this it will fail as in the criteria of the query it shows me...

I have been asked to extend a question that has been resolved once. I now have the code to build a query and also a spreadsheet from selecting items on a search form and check boxes from what I select from the list box and tick which ever check box I select it builds the query and spreadsheet...

The following code will list all the query names, but I want to list only the select query type or if possible as an alternative list the query names and what type of queries they are. Reason a lot of queries that have to be edited but need to do the select queries first.

I am importing data from Excel which is download from another countries system and the data comes with extra spaces and I have explored using Excels Trim Function before the data is uploaded and it is massively slow. So I am looking for some VBA (SQL statement) to run an update to the table to...

I am looking to generate a query based on selected controls in a form. The idea is select items from a list box (Multi Selection) then check some check boxes and it then generates a new query showing only the items selected from the listbox and what I have checked from the check boxes. I...

I have been request to see if this is possible. Convert a Lotus Notes Database with an extension of .NSF into an Access Database through VBA. I have seen that some websites are offering software to do the convert but I have been asked not to use 3rd party software. If anyone can point me in...

I am looking to create a table which holds exchange rates, but we only want to enter the month and year as the exchange rates are valid for a month not the day of the month. I looked to create a field and did use Date/Time set the properties as follows: Format mmmm yyyy Inputmask to 00/00...

I have recently started to build a new database using Access 2010 and have now found that the UserGroups have been taken away, and I was wondering if there is a way to set permissions from a table to allow certain users access to certain parts of the database, mostly all form access and then run...

I have the following code to create a comment box in a cell, but what I am after is for it to be filled with a range of cells, currently it will only add 2 cell contents.

I have created the following code to loop through all excel workbooks in a folder but it is failing on the transferspreadsheet as it states the F1 field not found, having checked several times the workbooks are all structured correctly and the access table has the same field names as I created a...

How can I refer to a filepath which contain text and numbers. What I am aiming to do is look through subfolders and return there name into excel, not file names. I have the code to look in a path as long as it is text but not including numbers. Example is as follows: M:\Order 1999 M:\Order...