Search results

Hello - Need some suggestions on the way forward with a Form \ Report design. There are two parts to data, 15 fixed fields, ie customer name, address, tell, serial number etc all laid out in a MS Word Document. The second part currently consists of 20 MS Word Docs that are just numbered lines...

Hopefully somebody can shed some light onto this, it's driving me nuts! I'm using Access 2007 I need to paste a column of data into a table. The table field is a standard text field. The data is a mixture of numbers and numbers with letters, i.e. 442513 442390 442473 442542 437284 260H 72H...

I have a sheet (AgentSummary) that lets the user cycle through a number of employee giving a score for various performance areas. There scores give a balanced score for the week. On a seperate sheet (WeeklySummary) the employees are all listed by row and week numbers across the top. To save...

Access 2007, Crosstab query . Evening - We've just started opening our business on a Sunday and this little issue has just manifested itself! We record volumes of calls previously just Monday to Saturday and the call volumes are grouped by week number. Which worked fine, now we open Sunday the...

Right I'm stumped. I run a small football based competition at work. The players predict the outcome of random matches throughout the leagues. What I want to be able to do is run a query to simply show each PlayerID against that the highest score they have got and the week that occoured...

I'm using the basic Password Challenge from this MS Bulletin http://support.microsoft.com/kb/209871 I have a FE \ BE based database but I'm Getting the error "3219" after the user has pressed submit. The Password form code is If IsNull(Forms!frmPassword!Text0.Value) Then...

I have a form that contains Customer Call Details (form A) and a seperate subform that contains customer address details. I needed a way for the staff to be able to search and list records by searching under the customers last name. I've achieved this using an Unbound text box on form A, that...

I have never done a stock \ sales database before, normaly just Customer Service or Booking ones. I'm still in the process of designing this new request and was wondering how you tackle historic data for sales items? At the moment I have a [parts] table that holds the PartID, decription and...

Anybody help with this annoyance. I've a continuous form that uses dlookup to grab a part description from a separate table. However on the records that yet to have a value selected I'm getting a #error in the dlookup field. The Control source is =DLookUp("partdescription","tbl_parts","partid...