Search results

Thanks for the reply, but no joy I'm afraid. The row source of the combo box is currently SELECT TblPaper.[ID No], TblPaper.[Paper Size], TblPaper.[Paper Quality], TblPaper.[Paper Type], TblPaper.[Sales Price] FROM TblPaper WHERE (((TblPaper.[Sales Price])>0)) ORDER BY TblPaper.[Paper Size]...

Hi Guys I have 2 tables, one, TblPaper, has Paper Size, Paper Quality, Paper Type and Price. The other, TblSale, has details such as date, staff name, unit price and total price and has a n-1 relationship with TblPaper. I've created a form based on TblPaper and have a combo box on the form...

Thanks Mile-O-Phile, it's working now Dave

Thanks for the reply Mike, but it already is linked to StaffID. I've used a lookup wizzard in TblUsage to get the staff names. In the design of TblUsage the SQL code is SELECT [TblStaff].[ID], [TblStaff].[Surname], [TblStaff].[First_Name] FROM TblStaff; Bound Column =1 Column Count=3 Column...

I'm currently designing a database for a univeristy reprographics department and am having a sloght problem. I have 2 tables- TblStaff, which contains Autonumber, Surname, First_Name. TblUsage, which contains info about photocopier usage as well as Staff_Name (link to TblStaff) I have a combo...

Thanks guys

Hi Mike Thanks for the reply. I've been trying to use the StrConv() function in an update query, but it doesn't seem to work. In the 'update to' query field I have StrConv(Surname, 3), so that all of the entries in the field 'Surname' will be converted. Unforntunately, everytime I move from the...

Managed to get problem No.2 sorted by using Data - Text to Columns within Excel and the importing the info into an Access table. Still haven't got Problem No. 1 sorted though :(

Hi Guys I'm designing a database for a local uiniversity reprographics department and have 2 problems with one of the tables. The table in question is the Staff table, which has a primary key (Autonumber) and the staff name. There are approx. 1000 entries in the table. I've imported the names...

Thanks Fizzio, the code worked a treat :D I meant to say in my original message that there were over 1000 cost codes, so a combo box wasn't an option. Dave

Hi guys I've already searched the forums and can't find anything to solve my problem. I'm designing at d'base for the university reprographics dept and have already come unstuck :( I have 2 tables Cost_Code and Job set up with a 1-n relationship. I have a form based on the Job table, with a...

Yep, the display is set to stretch. The actual size of the picture box is about 8cm*8cm as it is only an image preview. I'll play around with the display settings of the picture box, but I'd like the user to be able to see the whole of the image, not just part of it.

A few months age I created a database that allows users to view, categorise, search and store their digital photos. The image files are linked to the database. Everything was fine for a couple of months until a friend of mine invested in a new, more powerful camera. It seems he can't get an...

The easiest way is to put the following code under the forms Activate property: nameoftextbox.visible=false i.e. txtCancelDate.visible=false This will 'hide' the text box when the form is displayed. Then on the on_click event of the option button have the following code...

This is the code I've used. There is a command button on the form called cmdBrowse and a textbox called txtPath. Enter this code under the onclick event of cmdBrowse. Private Sub cmdBrowse_Click() Dim lpIDList As Long Dim sBuffer As String Dim szTitle As String Dim tBrowseInfo As BROWSEINFO...

Simon Thanks for the reply, unforunately that code only makes ALL of the selections/categories disappear in the 2nd combo after a value has been chosen in the first.

I've set up a database that allows users to view, store and categorise digital photographs. I'm creating a search form that allows users to search the database by Category/Sub-Category or both. On the search form the user is presented with 3 checkboxes labeled Category, Sub-Category and Both...

Thanks Pat, I've managed to just about get it working by having lots of combo boxes on the form and setting their visible property to false until a command button is pressed. It's probably not the best way to do it, but at least it works [This message has been edited by daveUK (edited...

I have a database that allows users to store, categorize and view digital photographs. I'm creating a searchform to search the database by Category, Sub-Category or both. There are 3 combo boxes on the form which aren't visible to the user when the form is loaded and 3 checkboxes(Category...

Thanks Jack I've been looking around an I've come accross an article concerning 'Filtering a Form on a Field in a Subform' at this address -http://users.bigpond.net.au/abrowne1/ser-28.html It seems to be what I'm looking for, but I'll try that MS article aswell.