Search results

Excellent, thanks for the reply.

Its OK, sussed it I think using this DateProcEnd: DateSerial(Left([DateProcEnd_YYYYMMDD],4),Mid([DateProcEnd_YYYYMMDD],5,2),Right([DateProcEnd_YYYYMMDD],2)) If there's room for improvement please point it out! :)

Hi, this is driving me nuts :( I've done it before for something similar, but i can't remember where I have a export in CSV that I've imported to a temp table. The Date is stored as 20101001 YYYYMMDD Before I'm sure I used an example using MID, but I can't find it. I've seen the use of Cdate...

Scenario first. Our employee's are scored on responses that they give to inbound customer emails. There are 10 questions and the score is calculated on the average of all 10 questions. Attached is my proposed table design. With help from another member here (Thanks) I know now the basics and...

I had a very similar question with a great deal of help from PNGBill he helped with a solution. Take a read here

One thing to check when using runtimes is you have a Default form to load when the frontend starts. Otherwise you'll generally get a blank screen.

Brilliant thank you, I owe you a pint. Now I can see what its up to knowing which bits are relating to the fields in my database it makes it a lot easier to understand. Oddly It also helped when I thought about it as like how I configure our telephone switch with Direct Dial Number to Extension...

Hi there. I yes the fields are text boxes and the gsfs doesn't change. Posting from my mobile as my net connection has just died. I did find another example of the loop but can't see it on this phone. I've bookmarked it so i'll take a good look when I can get back on my PC.

The problem I have is I'm trying to reference you code, not knowing really where to start! You mentioned a control on the form to specify how many questions, is there something similar on the code you posted? Also which part of your code takes the txtQ1 part and adds 1 as part of the loop...

PNGBill Thanks very much :) I have got it appending the 1st field and understand in a limited way what it's doing, also found out what a _ does at the end on the line from this post. Below is the code I have in place that works, may not be perfect, but does the job. I've used your code and...

Thanks for the reply :) However thats a little above my current ability, so a little help would be appreciated. Using your suggestion, I thought I start small with just getting two fields to append to a table. I'm stuck allready. I've created a query to see the SQL code which I do understand...

Hi all, I've searched the forums for surveys and questionnaires, picked up a few pointers and watched a online tutorial here but found it was based on a non normalised table. I've created the survey as a non normalised design, works fine, just getting reporting hicups with null fields etc, so...

I have a small Database split FE \ BE each user has a local copy of the FE on their desktop. The FE settings are set to No locks and Shared. The parent form is tied to a table. There is a sub form (tied to a table) on the parent form. The is a onCurrent event that checks to see if the main...

Perfect :) That's makes everything very clear! Thanks - I'll see how this plays out in the next few days. As a side note, I've learn't more in this thread, than the whole of last week reading the Access book sitting on my desk. Cheers guys! As for the Date field name, its got a unique name!

jdraw and everybody else, thank you. I just spotted the Indexes button button in Design View that seemed to make things click. Poppa Smurf suggested adding the date as part of the primary key? Wouldn't this then allow a duplicate course and employee to be added the next day? The coursestaken...

OK, cheers Jdraw. So doing that creates an index of the two fields, that in theory must be unique to every record. Probably my screwup, but I think I know what has happened. Here's the current table setup. courseID - autonumber CourseName - Text EmployeeID - Autonumber EmpoyeeName - Text...

Thanks all for you help :) I think I understand the concept of the composite field as I use something similar in Excel to vlookup a incoming DDI against a specific date. What I really dont get is the concept of a composite field in an Access Table. The MS help file in 2007 explains a composite...

Cheers all. The helper doesn't work with me, I just ask here and there when I can't work out how to do something. The current database isn't live as such, just started it to see if I could do it. Can you explain what a 'composite' field is and how and where it gets the data from. I've searched...

Thanks! Yes I do have Employee Table, Course and Taken table. In the CousesTaken Table I have the fields EmployeeID and CourseId. Looking around to find out what a composite primary key is, I see that I need to make the EmployeeID and CourseId fields in the Courses table both Primary Keys...

My normal access helper is away at the mo, so he's told me to ask here! I have a training database that stores our employee's training records. The main courses table has various fields that store data, two significant ones are CourseID and EmployeeID. Now the little issue I have is when...