Search results

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 :(

Hey all I'm looking to get Access 2007. Anyone know the cheapest place to get it? I'm in UK but if importing is cheaper I'd be interested. Thanks for your help

Hello Eddi You can change the background colour property and locked property of control programatically using VBA. Something like: With Me!txtControl .BackColor = Gray .Locked = True End With Access does not have a datagrid control like VB but you can have continuous...

Try setting the number to the value property instead. me!boundfield.value = "22" The text property holds the current value for the control while the value property holds the saved data for bound control. When you change the text property, the info has to be saved to the field which is done...

Yes, you can use code to update the value.

Thanks guys for your help with this. I'll try out a few things and see what turns out best.