Search results

It's possible, but a bit tricky. imo, you want tables on the styles, the order groups and the prices. Style table info would include the code & description. OrderGroup table info would include columns for group names (Price_1000-4999 etc) and the max and min amounts for that group (1000 and...

Can you use the Column property of the combo? PrevLocVar = Forms![frmRefCase]![frmRefCaseSF].Form![RelocStore].Column("StoreNumberColumn") & " " & Forms![frmRefCase]![frmRefCaseSF].Form![RelocStore].Column("Suburb/shopNameColumn") Me!PrevLocation = PrevLocVar hth mcalex

I have a subform (datasheet) inside a subform (single form) inside a form, and am only seeing one record in the datasheet subform. I am creating a database of database jobs that need doing (basically a ToDo list). The main tables look like: Databases <-1----m-> Jobs <-1----m-> Tasks In the...

haven't come across this myself, but Can you trap the error that causes the halt message and then programmatically compact and repair the user's front end? this might help with the second bit: http://www.access-programmers.co.uk/forums/showthread.php?t=160025 hth mcalex

:-) cool. happy to help

Spot On! okies, first you need to see what is calling this method, and why the parameter being passed (bWasNewRecord) to the method is false. If the above is all the code you have, then an event (like a button click, or a checkbox selection) is probably calling the method. Have you used VBA...

You can have, say, a DataEntry front end and an Administrator front end, but the way i've mentioned means that any changes you make that everybody needs to see only have to be made once. Additionally, if you later find there's a third user type, you don't have to create another front end for...

You can find the user with the Environ command but it seems there are sandbox issues. See: http://www.access-programmers.co.uk/forums/archive/index.php/t-76173.html Or there's the Microsoft way which uses Windows API calls. See: http://support.microsoft.com/kb/152970 Either way, put all of...

try here: http://www.access-programmers.co.uk/forums/showthread.php?t=202278 hth mcalex

@plog ummm, not really. As suggested by the need to split the table, there are quite a few fields (about 120). The information relates to a council's budget, so the bulk of the data are financial (currency type). There are also a number of boolean, date/time and integer fields related to...

Had a closer look at your code ... not sure this is the right answer. check your AuditEditEnd method to see what is being passed in. It looks like bWasNewRecord is always a false value. check it with something like: MsgBox "New Record: " & bWasNewRecord in between: Dim sSQL As String Set...

Not really sure what your question is, but if you change: "SELECT 'EditTo' AS Expr1, Now() AS Expr2, NetworkUserName() AS Expr3, " & sTable & ".* " & _ to: "SELECT 'Insert' AS Expr1, Now() AS Expr2, NetworkUserName() AS Expr3, " & sTable & ".* " & _ does it work like you want?

You don't care what the transaction ID is. Therefore it doesn't matter if it is in order, in sequence or in hexadecimal.If you need a sequential, ordered field, you should add it as a column, but don't use an ID field for it.hthmcalex

Hi all I have a table where the number of fields is causing problems. I want to split the table into 3 or 4 tables with related sections, but am not sure how to maintain the connection to the logical row of data, and how best to do this in Access. The data relates to council budgets, and...

okies, worked it out It was a primary key issue. The query - and others - includes a linked table in a Sql Server database. The Sql server was moved from one box to another a while back, and therefore, I had updated the linked table with the dsn connection to the new box. When I did this I got...

hi, nice step-in missinglinq, i was visualising things wrong - thanks for the clues. (I gotta get better at this helping stuff) noboffin: what Linq said is right. Sounds like you need a form with 'Owner' and 'Total' textboxes, and a subform with a 'Cost' box, and unless the data coming in...

OK, think i've got it. Your total textbox can be set to something like: =[detailItem1]+[detailItem2]+[detailItem3]etc where detailItem# is the name of the text box with the item cost in it. I'm not sure about your formula, coz the inputted item costs won't be 'owned' by Bill until the data is...

hi noboffin a bit confused as to where the cost items (that need summing) are coming from. If they are being entered into text boxes on the form, then each textbox could have a LostFocus event that adds the textbox content to the totalCost If they are coming from the database, you could...

OK, the adding 'query'/RecordSource is just the table, but the editing query/RecordSource is a query based on the existing entries in the table. I'm dealing with an annual survey form sent to existing customers. Basically, the form is a 1 to 1 mapping to the table, but there are some links to...

Thanks guys searching 'uneditable recordsets' as we speak :-)