Search results

Am trying to delete info from tblA that exists in qryB. SQL: DELETE tblA.* FROM tblA INNER JOIN qryB ON (tblA.fld1 = qryB.fld1) AND (tblA.fld2 = qryB.fld2); I view the results in design view. Shows the 42 records that I want to remove. Run the query: "Could not delete from specified...

I am in the process of converting all of our databases to Acc2k and in some cases I am unable to do so. This is because Acc2k comes up with: THE CURRENT USER ACCOUNT DOESN'T HAVE PERMISSION TO CONVERT OR ENABLE THIS DATABASE. Having reopened the database in Acc97 and gone to Security / User &...

I run a monthly code that appends data to a table, then runs a make table query which manipultaes the data into the right format for export and then loops through by building a query using the QueryDef code to create the site specific exports necessary for Excel. In 97 it works fine. In 2000...

Am trying to convert a database from 97 to 2k but when I open it in 2k it gives an error message saying that I do not have permission to change it. I can open it and build edit etc in 97. What do I need to do? Thanks in advance

Am using code to open a query to see if any records exist. At the Set MyRS = currentdb.openrecordset..etc I am getting Run time Error 3061: Too few parameters Expected 1: When I go into help it says:"This parameter query requires the specified number of parameters, which you didn't supply...

I have a query that will return any thing between 40 and 127 rows. This needs to be translated to a table with 40 to 127 columns ie 1 column per row. Having created this I need the new columns to be YES/NO. Filling the YES/NO boxes in code I can do but I do not know where to start to build...

Have a report showing trunk lines which are 9 / 10 characters long starting with a zero ie 001002015 Have set the row source for the graph as text, set the graph as text set the axis format as text. It looks correct in design mode. Open it in preview it loses the zeros and shows 1002015 HELP...

I have a list of extensions that can change on a monthly basis. I need to use code to assign data to variables being one variable per extension. Is there a way of having part of the variables name being the extension number (ie for extn 4932 have variable 4932Call)

Have code that rewrites the feed query for the report so that I have one report per department. All works fine, shows the correct records etc, except that occassionaly the graph shows the values from the sample (design view) rather than the query. Have put code in the OnFormat event of the...

On a form, I have lots of comboboxes where column(0) = ID Number. Next to each combobox there is a textbox. I need to assign the information from the textbox to a variable. The problem is that I want the variable to have the name Lx where x is the ID number from the combobox. So something like...

I have a database that keeps control (MAIN.MDB) and is the user interface of about 200 other databases. These other databases can also be used manually Reducing the problem to 2 database. MAIN and SLAVE. SLAVE is a database that creates reports with 1 form which allows the user to choose...

A year ago Travis posted some code to connect to Outlook. I was wondering if anybody knows how to amend it to view a specific Mail account. The reason that I ask is that I want to have a mail account setup purely for an Access DB to read, called "Autoread". How would I put it into the...

I think that there is an easy solution to this problem. Table keeping details of contacts. As details can never be deleted, just flagged as old, whenever they change a new record is created. This means that if I have 10 contacts, in theory, the last record in the table could be the details of...

I am trying to find an easy way to see if data in a textbox has been changed when it loses focus. 1 Is there a compare command or; 2 Is there a way in which I can assign the contents to a variable and then check that variable against the 'new' contents or; 3 Will I have to dump the original...

I have a form that shows a client address fed directly from a table. If the user changes the address how do I get the data to be treated as a new entry in the table as I do not want the existing record to be changed? The change will be confirmed by clicking a button so I need something for...

I have a graph that I want to export in JPG or similar format. Does any one know where I can find the suitable addin?

I am going round in circles. I have a form which allows me to edit records in a table. I want to be able to type in the index number and then the record will show in other text boxes for me to amend. Either I get the data into the boxes but they do not update the table or I get #Name? What...

Sure this is simple but brain hibernating for the winter. How do I get VB Code to place my cursor at the end of a string in a textbox? Textbox is the focus. Thanks in advance Simon

I am trying to view details in a list using a combo box and a textbox to narrow the criteria. I want the textbox to behave the same way as in Help where whilst you are typing, the list is updated. The combobox is to limit the selection by category. I have an On Change code of me.refresh but...