Search results

From a form i have a command button that gives an excel out put of a 3 querys onto 3 tabs of an excel file. It then opens the file and formats the data slightly. This works fine. Once then if i try the same thing again it give an error. If i close the db re-open and try again it works but only...

I have a complex Form with subform. The subform is based on a qry which pulls data from a temptbl. I want to be able to re-create the temptbl and then requery the subform. Access wont allow me to delete the old temp table as its locked in use on the subform. Is there some way of disconnecting...

I have a wizard that allows users to easy import excel data into the database but on occation a bad record in the excel file will cause the database to create a Sheet1$_ImportErrors table with 1 record in it. Is there anyway to Delete these tables automatically? Many thanks Sam

I have a Continuous Form with lots of field based on a complex query. The User can Click on a number field in the form and a pop-up form opens, this form allows them to change the number. When they close the form i run code to requery the main form. No worries there but.. the focus jumps...

Im attempting to edit a few fields of a selected records in a combo box. I often use a piece of code given to me by Pat in a earlyer thread. I have changed the code somewhat but can seem to get it too loop through the selected records and edit the fields i want. Heres the code. It runs but will...

I have an established database running on a server. But i need to web publish some querys from the database. Im going to use coldfusion but need the Backend Db to be on the web server for this to work with the set-up here. I dont want to move the location of the Db for speed reasons. I propse...

I have a designed a database over the past few months and finally gone live with it. Its basically a stock control system. One user keeps managing to crash it (hang it really), on switching on the Access to the VB its giving a syntax error in the key section of code. The code basically takes the...

I need to build a numbering system for new records in a database that combines. month date and ticket raised in day. So today would be 2/9/ and then the ticket raised number 2/9/1 for the first 2/9/2 for the second ect ect. I need to use this method as its replacing a current system and they...

I have a running sum on a report. Can i stop the running sum once it reaches a certain number. Many thanks

Im having a puzzeling problem with a form requery. I was happly using requery to requery a form, but once i installed the DB FE onto another users machine, the code stopped at this line. so i replaced with me.form.requery which worked fine for a while but has began to crash the DB giving...

I have a select Qry that im outputing into an excel file. I can name the field titles to better names ie. 2003 results: [x]*[Y] Which is fine but i want to be able to show year name from another field in my form. ie =[year] & "results": [x]*[y] i know you can do this in text boxes but i can...

Having great deal of trouble with this one getting error 2 few paramater expecting 2. From reading other posts i think i need to declare the paramaters in the statement somewhere but ever combination give me some diffrent error. Can anyone help? Function UpdateAmounts(intRawMaterialID As...

Im having a problem printing a report to scale of 50%. When i change the scale in the printer set-up it just prints a single page of the report at half size per sheet of paper. What i want is it to fit to pages of the report on one piece of paper. The report in design view is one page, but is...

freeze panes can it be simualted? I have a continus form displaying a list of names and vaules realted to each name. There are more values than space on one screen so the user has to scroll across. Anyone know of a way to freeze panes like in excel to allow the user to continue to see the name...

I Have 3 tables tblEvents -eventID -eventName -EventDate tblTrim -TrimID -Name Tblschedule -ScheduleID -EventID -TrimID Tblschedule is basically a many-to-many link table showing which names are going to which events. I want to create a qry that Looks at the date of events and tells me if...

I have a form with 2 listboxes. i highlight a name in the 1st listbox and click add, a record is added to a many-many link table and the 2nd list box is requeried and reflects this change. All works well but i want to use a multi select box and a select all/add all button. I have read many posts...

Im begining work on a new database and would like to get the structer and relationships right first time( for a change). Basically its a simple training request database. It will allow users to request --Individuals to go to a particular training event. (TrimID identifys user) --Groups...

I have a text box on a form containing a sum of several other boxes. I want to store this value in a field. I am using a on click event me.box = me.box2. This works fine on a Single Form, but on Continuous Form it only does it to the record I have selected. I Have tired on_current event same...

SQL I have his code running in the database no worries, but I want to Change it so it takes the "adjustment" value from a qry not from the table "newstock" As im having to update this before i run the code and it causing trouble. The code reads... Dim rst As Recordset Dim dt As Date Dim...

I have a large stock control database. The User want to be able to try out changes in supply and demand in a "virtual database" so they can try things out, if they work they then want to keep them if they dont they want to ditch them and returm to the orginal. Anyone ever attempted this before...