Search results

I am struggling to get my head around this. I am trying to setup a football dream team db based on 3 tables of data, these tables will hold player data. table1 from start of season, table2 from 1st transfer upto 2nd trasnfer and table3 2nd transfer to season end. My thinking at the moment is to...

I get this problem when I try and open excel files a warning box saying File already open by user 123456, open as read only However user123456 is me and I do not have it open. Anybody know what causes this or how to resolve? It doesn’t matter what PC you try to access the file with it...

It is probably the Trust Centre settings. You need to alter these to allow the code to run rather than be blocked. You normally get a pop up message below the ribbon menus that you sleect to allow the content.

not sure how its all setup but is the value in the list box being passed to the sql string? It sounds like it might not be.

I have a strange thing happening with an access 2007 database. When I query data it omits 1 record. If I then requery the record is included. This happens on all of my querys but only the first time one of the querys is run and it doesnt matter which one you run first. Anybody got any ideas on...

You can run a query from a macro, so you could create an update query. Not sure it quite fits with what you want to do. When you run the update query it will want criteria for the field in which you want the new data, I assume is not the same data for each record. So you would need to pass...

I have a pie chart that picks up the legend from the underlying datasheet , however the number formats are incorrect. I am getting numbers like 42398 of Nov-15 when I should be getting 11-15. Any ideas how to resolve this, I have tried changing the format of the cell but I can't get it to...

Don't you hate things like that, been sat here for ages looking at this. That did the trick, thankyou.

Maybe I have been looked at this too long. This nested IIF gives me a syntax error, maybe its wrong, I have checked else where and this is how to do it. Can anybody help/see what I am doing wrong. expr2: IIf([expr1]=6,“6-10”,IIf([expr1]=7,"6-10",""))

I needed to conditional format once and found a way that worked, not perhaps quite what you want. It involved putting many controls onto the form over the top of one another and setting the following properties to display the control if the condition was met. Obviusly each control would have...

You would be better creating a query based on the table then setting the forms record source to query you ave created. You can then specify criteria in the query design to select and display the records you want.

Perhaps you could try a different route, depends how you have designed the database. This is an example of adding values to a table running from a form, text boxes and command button. Private Sub Command1_Click() DoCmd.RunSQL "UPDATE stafftable SET [age]='" & Me.txt1.Value & "' Where [name]=...

It says you are losing 10 records, is that all you are appending or are there more records that have been appended / accepted? key violations are usually down to primary key field data and referential inegrity, probably duplicating primay key field values or may be you need to edit the join.

Could do with a bit more detail, What data are you updating the table with?

The network speeds are fine. I shall give your suggestion a go. Thanks

Thanks for the link, this is my code now (or my best stab at it) however it is no quicker then ODBC linked tables. Any idea why? Something I am doing wrong with code or is the fact I am connecting to a .dbc rather than free tables?? Private Sub Form_Load() Dim objCon As ADODB.Connection Dim...

OK, I am not the best when it comes to code. I have been struggling with ODBC connections for FoxPro databases and have been forced down the route of OLEDB drivers instead. I think I have connected with the database (the code runs) but how do I retrieve the data I want? The only way I know is...

It all depends how the database works in its current setup, how you want it to look etc. Assuming that the form displaying your records is based on a query you could make it a paramater query.

Just add soem more detail to this. I have created a query on the linked tables, it is a valid query and returns the records I want. When I try to create a form to display these results using the wizard it doesnt want to know (Not responding). I have tried creating a blank form adding the new...

I have a PC with access 2007 on it and it will not stop hanging at even the most simple of things, such as deleting a control from a form. :confused: I have linked tables to a foxpro database but I am not actually processing anything, running queries so can not understand. Has anybody...