Recent content by Carl Foster

Thanks, found the problem. One of the fields in the table I was trying to append the data to was a required field but I didn't update that field with the append query.

Hi I've just created and append query. On running the query it displays this message: Microsoft Access can't append all the records in the append query Microsoft Access set 0 fields to Null due to a type conversion failure, and it didn't add 0 records to the table due to key violations, 0...

Actually, I've just found something in MSDN that I think will help. If anyone is interested heres the link: http://support.microsoft.com/kb/296249

Haven't done this for a while and just resurrecting this thread again. I am using Access 2007 in which you can easily create summaries for groups and for the entire report using a textbox and this within the control source =Sum([curReceiptsIn]) where curReceiptsIn is a control within the...

Hi I'm creating a report with a whole list of currency transactions. The report needs to sum up values and display a running total at the bottom of each page and then a "Totals carried forward" at the top of page 2 with a final sum at the end of the report. I can achieve a final report total...

Solved Thanks for all the suggestions. I've managed to get a working solution. Basically, I made the single form bound at design time and the datasheet I bound using ADO. When the form first loads and the datasheet is bound programatically, this also triggers the on current event. In the on...

I don't know if any of you have Access 2007, but if you do, I'm trying to achieve similar functionality to the new Split Form style implemented. I have managed to get some of it working. I inserted 2 subforms onto one form, both unbound but one in single form format and the other as a...

Thanks Dennisk. I could use a list box to do what I want I suppose, but the reason I wanted a datasheet subform is so the user can see a list of all the records and he can view a - z for different columns too. Then if he selects one the info appears on the main form There just appears to be...

Just wondering if it's possible to create a form with subform where their control sources are the same. I would like to have the main form as like a single form with data entry, then the subform showing the same table data but in a datasheet format. If I select a record in the datasheet, then...

Thanks, yes that is the problem. Thanks very much

Thanks for your reply. As you can see though, there is a field lngDepartmentNumber shown in the SELECT part of the statement. Also, the variable lngDepartment does receive a number during runtime. I've even substituted the variable for a number and it still gives an error :(

Hi all, do you think you could help me with this SQL statement I'm using in vba code for a recordset object? strSQL = "SELECT idCompactPartNumber, txtItem," & _ "lngDepartmentNumber , dteAquiredDate, curPrice," & _ "intQuantity , lngUnit, txtLocation," & _ "imgPicture, dteRetiredDate...

Well, I'm not very proficient in VS and coding the front end of a database in VS, while perhaps providing much more control and flexibility, is quite a bit harder. So, at the moment, I prefer to use Access until I get better at the whole thing.

Hi all, I'm trying to find a control like the panel control in Visual studio, or at least some code to create one :eek: It's a container style control, but the feature I'm hoping to have is the ability to click on the border during runtime an resize the control. Kind of like a grabbar between 2...

Well, I'm not a student :( So I guess I'll have to go with normal price, which is over £100 :(