Recent content by JM79

Ok... I have a report with 2 groups Department Employee The detail in the report is numerous rows of overtime hours by employee. Its supressed and a summary (total) of the hours is put into the Employee group. The Group Sort Expert has also been used to give the Top N (Top 5) Overtime...

I have a checkbox in my subform. if I check it true I want it to copy the values of a field in the form to a field in the subform Why isnt this as easy as Private Sub copy_caller_Click() If caller_copy = True Then subformcaller.Value = formcaller.Value End If End Sub TIA

I have my main form which is connected to my main table - Query 1 I have a lookup table (actually a view from SQL Server) which holds my user name - the username used to login to the database- just one value. In my main form I have a 'Logged By' field. I want this field to default to my...

run your select statement in SQL Analyser to extract your addresses Copy and Paste your rows into excel. Go to Data - Text To Columns. Follow the instructions. You move the vertical lines about to sperate cells. i.e 13|Rowbourne Lane|London. Press Finish and it seperates all the cells for...

export it to excel - use text to columns, load it back in ! HTH

Just tried to open my ADP on 2 seperate computers with different user names and it said that it could only be opened for read only - or that id saved it as read only. Its a database FFS so why is it saying its been locked by someone already in it ? It does let you in after you've OK'd it and...

Hi, Just getting used to this. Im not really an Access programmer nor SQL but I thought id try my hand for a call logging company system. I have a few questions 1. Autonumber. Why does it not create a number as soon as I start inputting into the first field? I have to jump out of the...