Search results

I have a table imported to a spreadsheet from Access containing a duty and a staff number DUTY STAFFNO Rest Day 123456 Rest Day 234567 Annual Leave 345678 Earlies 456789 Earlies 567891 Lates...

I have experienced a problem copying a database from a CDR to the C Drive of a networked machine at work. What happens is that the Database attributes are changed to "Read Only" after being copied. I can change this easily enough but i dont want other users to have the same hassle. This problem...

I have a database with front end and a back end databases. I want to share this database with other users on CD. The problem is that when copied to a local hard drive from the CD, the read only properties of the databases are set. Rather than rely on the user having the knowledge to right...

I know how to protect a worksheet from being changed by the user but this does not seem to prevent it being deleted. Anyone know how to accomplish this Cheers

I have a database that adds the details of orders to a spreadsheet <Order Book>when they are made. This works fine When the orders are recieved the same spreadsheet<Order Book> is opened, the corresponding record is found and updated with receipt number and receipt date. The following code when...

I have read the thread concerning hidden toolbars in Access requiring a custom toolbar in reports. But i do not seem to be able to get rid of the windows close button. Obviously when pressed closes the database altogether...Which is baaad Any ideas?

Can anyone tell me why having used the following code on all my forms in a database without any problems: If DateDiff("d", Now, "01/04") <= 0 Then Me.txtYear.SetFocus Me.txtYear.Text = Year(Now) & "/" & (Year(Now) + 1) 'Date is past 1st April Else Me.txtYear.SetFocus...

I have a clothing Database that orders and issues clothing items to members of staff. The program also keeps an account of clothing not issued and therefore still in stock. In order to have a written record of this, i have been able to write a routine that creates an Excel Workbook that puts...

I have a button in Access that populates the worksheets of a template in Excel. Each instance of a particular item in my table is added to its own worksheet and the worksheet is renamed according to the item description. This works fine but only if there are enough worksheets in the workbook...

I have a [frmMain] form which i would like to run maximised. I also have a button on the [Main] that opens another form [frmAdjust] in Popup mode, because i do not want this form to be maximised. The problem i have is that when i return to the [frmMain] after closing the [frmAdjust] i want to...

I have a textbox on a Subform which is updated when a record is double clicked in another Subform. This works fine until i move the mouse over the updated subform. Then the updated entry is replaced with #Deleted. The data is still in the table that gives the subform its value. Also another form...

I have a form [tblStock]with a combobox bound to the Primary key [ContactID] of a table [tblContacts]. Also on the form is a subform[subContacts] bound to a query that is based on the value of the combobox on the form. So that the details of the combobox[ContactID] is shown in the subform...

I am a relative Newbie so if my question sounds stupid, bear with me: I have a form with a subform linked to a query. On the subform i have a checkbox[Recieved] and when checked adds a date to another field [Year] on the subform which in turn updates the record in a table[Orders]. I then...

I have a Mainform with a subform linked to a table. Within the subform i have a number of individual checkboxes and a field [Year]. One checkbox, [checkboxIssue] i have wanted to link two update queries in order to update the field[Year] with the contents of a [textboxValue] on the Mainform...

I have a database that allows the user to order clothing items. Each size of each item has a different stock number. I have [StockNo] - [StaffNo] - [Qty] i need to generate [OrderNo]. The problem i have is that [OrderNo] is incremented after every five five items (ie[StockNo]). This gives me...

I have a form with a subform in dataview and wish to append the selected record in the subform to another table when double clicked. I have the following code in the double click event of the subform. Private Sub Form_DblClick(Cancel As Integer) Dim strSearchName As String...

I have a form with a subform in Datasheet view. I want the user to double click a record in that subform and a query to ammend it to another table. I want to trap the double click event of the subform but how do i run a query based on a current record in a subform?

I have a database with the tables linked from another database. The problem is that i need to copy the database to and from another machine in order to work on it. As this involves putting it in a different location each time, i have to relink the tables. Is there a way to link the tables...

I am trying to force a query to select all fields with a zero value but to carry out a different query if the value is more than zero. I have tried with IIF statements in the criteria but without success. ie IIf ( [tblClothing]![ChestMax] = 0 , [tblClothing]![ChestMax] ...

I am trying to create a query that gives me a stock number relating to an item of clothing dependant on the sizes of the person concerned. When working i will make it into an update query but the criterea's seem to have a problem with each other. I Got around this to an extent by using IIF...