Recent content by Hartkoorn

Hello all, I have a question; I have 2 databases with 4 tables in it following the same structure. Table 1: tblPersons consisting employeenumber as pk Table 2: tblLocation consisting the location as pk Table 3: tblCompanyvehicle consisting the licenseplate as pk Table 4: tblAssets consisting...

Now, I don't know if this topic should be in forms, queries or reports, so I decided to post it here in general until someone gives me a big bollocking and send this topic elswhere :D I have a table with loads (50+) of columns which hold information about people in our company. What I want is...

@Hayley: If I use your db example (after converting to access 2003) and click the send option, all dots are replaced by semicolons (ie someone@home.com -> someone@home;com). Anyway to avoid this?

Wow, Thanks, it works perfectly!

It must be me but: I have a table with the column Grade and a column Grade_Group In the column Grade I can give a value from 0 - 10 (pull-down). When I grade between 0 and 3 I want the column Grade_Group to be updated to Low (easy, even I can do that with an update query). But if the grading...

Sorry to nag you again Matt, But the listbox keeps on returning the SELECT statement. Must be going bonkers here, did I miss something in the listbox properties? I attached a screenshot of the form in view mode and the VB code window, maybe I'm missing something here.

LOL so even VB programmers are human after all :) Thanks for the quick response mate!

Thanks for the fast reply, there's just one minor thing: As I open the form the listbox shows: SELECT [Werknemernummer], [Naam] [VoorNaam] as Employee, Left([Werknemernummer],2) as AgeFROM Persoons_Gegevens WHERE [Werknemernummer] = #06 09 01# I added a record with a person who has its birthday...

Our company has a employee numbering system like 65.01.20.HAR this is also the primary key that I use in the table. The employee number is build up like this:65=year 01=jan 20=day HAR=first three letters of last name, so 65.01.20.HAR is me Hartkoorn born on 20-01-1969. Furthermore I have...

Tried to add the following code to the onClick event in the tab but it doesn't work, any ideas where to put the code? Private Sub Rapporten_Click() On Error GoTo Err_Rapporten_Click DoCmd.GoToRecord , , acNext DoCmd.GoToRecord , , acPrevious Exit_Rapporten_Click: Exit Sub...

Now I found that if you move up one record and down again the data does show when viewing the report. Is there a code which moves up one record and down again which I can run when the Reports tab is clicked?

K, Going great now, mainly due to the information found on this forum. Breaking my head again on a thing here: I have a tabbed form, one of these tabs is called reports, the others used to enter information. Now if I change some data in the form and switch to the reports tab and hit the view...

Ta, Works! But still unable to show (for example) the version and department in the header.

Sorry, clicked twice, forgive my double post

RV, Wow, that was fast and clear! I'm fiddeling about with it now, is a subform not going to work either? It just crossed my mind, but if not possible I'm not going to bother with it. Ta