Search results

so in the button onClick event you want something like combobox.itemselected=null textbox=null Sorry, I can't remember the proper syntax right offhand.

With this in mind, you could consider allowing selected users to design their own queries - but only allowing Select permissions on the tables in order to prevent them changing underlying data.

Hi, Is your form bound to a query which is non-updateable? Some querys return result sets which cannot be updated as any update would be ambiguous. If you have used 'group by' in the query for instance. Also Are there any error messages when you click 'new record'? Does it present you with a...

Is tblRef_Payment_Period the place to store base salary data? or does it store actual payments made (taking account of deductions or bonus payments)? If the first, you could replace it with the table I described. e2a: I personally prefer 2 date fields to define a period, but there are...

Hi David, I am trying to do the second option you gave. Sorry, I should have labelled my explanation more clearly.

tblEmployees likely does not need the resigneddate checkbox - if the date field is null then they haven't resigned. Gross salary might want it's own table since it could change per person over time. Table would be something like ID (PK) EmployeeID(FK) Salary DateFrom DateTo You are using...

Can anyone tell me how to get from this Table1: T1_ID Notes 1 note1 2 note2 to this Table2: T2_ID Notes 1 note1 note2 ? I am trying to make notes from an old database available in a new one which has a different structure.

What happens if you don't refresh? I find that problems arise if the networked drive is not mapped in Windows *before* launching the front end application. This could be a bigger problem with your slow networked drive. In such cases I could refresh the linked tables but closing and re-opening...

You can avoid storing CNAME in both tables. Only CID needs to be in both. After that, you could use a main form for Customer and a subform to show all orders for that customer. The subform wizard should get you started.

I think you should aim to make one list of addresses the 'master' list and link both of your data tables to (in this case) your spreadsheet on the server. Ideally you only want to store the text of the address in one place, with a primary key, and use that primary key as a foreign key anywhere...

Could there be any advantage in keeping the queries on the VPN desktop? I'm wondering if having them on the remote machines means all the data has to pass down the VPN link in order to process the query but if the query lived on the VPN desktop then only the results would have to travel. (This...

Looks like you want a table of all the music in your collection, then another table of all the occasions when each piece of music has been performed. You could do that by linking your table of unique pieces of music to a table with just a date column and a MusicID column. The MusicID column is...

Could be that the report is larger than the paper page width - the result being that what looks like page two is really just 'the rest of' page one although no report elements are actually printed there. Try tweaking margins in Page Setup.

Something like Select Top 1 SerialNumber from TableStock Where TableOrder.CodeNumber = TableStock.CodeNumber Order By Date DESC; Caution: Above may be faulty and/or contain syntax errors so double check and test before going with it! The idea is that it takes the oldest item with a given...

Hi, I think you need to specifiy 1 employee to many training events. Can a manager also be an employee? Your existing relationship there makes sense but there might be another way to implement that concept. Consider a new table tblSubordinates with a relationship 'one employee to many...

Hi, I normally open my database via a shortcut so that the correct security information file is used. When I tried to connect Visio to the database (via the database wizard) I got an "unrecognised file type" message when trying to specify the shortcut (database.mdb.lnk). When I tried to go...

Not sure if you want people to be able to view and modify data from the database via the web, or if you want people to be able to modify the database itself via the web. I think both are possible but the second one is tricky. If you just want people to be able to view/edit data, take a look at...

I did just that - does it make a difference to Access or is the shorter form just easier to read?

You've pointed out my schoolboy error! I'd forgotten to count the single quotes. By requiring at least 7 characters I now get the right result. I'm posting the code anyway, since you asked. Thanks for the heads-up. Private Sub btnPanelNameSearch_Click() Dim RsNames As DAO.Recordset Dim...

Hello, I want to enforce a minimum string length in a search. The following code gives the messagebox when the text box txtNameSearch is empty, but proceeds to fill the listbox with results if the text box has one or more characters in it. Is there some special issue with asterisks in this...