Search results

I'm having difficulty in creating the VBA code required to - on the click of a button on a Form - insert some data recorded on that Form into a Table (ie. one that isn't the source for the Form). The data recorded on the Form that needs to be inserted into the (other) Table : dtTestDate...

Could someone help me pinpoint where I'm going wrong with the following, please ? I'm attempting to insert a record into a Table named tblTasks, using the VBA code below. Dim strTaskInsertionSQL As String Dim strTaskTitle As String strTaskInsertionSQL = "INSERT INTO tblTasks (TaskTitle...

In my database, I have a 'Quote' form with a Quote-line-items subform (sfrmQuoteLineItems) and a 'Sales Order Form' with an 'Order line items' subform (sfrmOrderLineItems) In the header of sfrmQuoteLineItems, I've placed an unbound field (unbQuoteLineItemsRecordCount) to provide a count of the...

I'm trying to create a database based on the Northwind 2.0 Developer database, but capturing & displaying dates (including stock-take dates) in Medium format (dd-mmm-yy) instead of Short Format (as in Northwind). I'm encountering a 'Invalid use of Null' error (Error 94) that point to the...

In recent days, a colleague sent me an Access database to make some changes to, and I did, and sent it back to him. On opening it, my colleague encountered a compile error : Compile error : Can't find project or library On looking at the 'References' list (my suggestion), he saw amongst the...

The scenario : I have a Subform1 set within a 'Main' Form. Within Subform1, I have a control (Field1_PK) and a Subform2. On Subform2, I have a combo that takes its data from a lookup Query. Within the Query, I want to be able to limit the records to ones that have a value set to that of the...

'Tables' seemed the most appropriate section to post this in. I have an idea about storing blocks of HTML code as the Default Value in a Long Text field (for an application that'll allow me to cherry-pick blocks of code for compiling web pages). And I've been trying it out (placing the HTML...

Hi. I hope someone can provide some helpful hints or tips as to what might be happening : A business acquaintance recently asked me to take an 'old' Access database (at least 5 or 6 years old) and make some changes to it, updating it to Access 2021. And that I did. Elements of it weren't easy...

On a continuous Form, I'd like - if possible - to be able enter two digits in intField1 and - without having to hit the Tab key, or click on txtField2, etc - to have the focus set to txtField2. Is that achievable.......in VBA or otherwise (maybe via a Validation Rule) ? I've been trying the code...

Hi. I've already been searching around for a way of doing the following, but I haven't yet been able to find it. I want to have a 'continuous' form showing various fields, including a dtDeadlineDate. Alongside the dtDeadlineDate field, I'll have a unbBusinessDay to capture the business day...

Must say I've never seen this happen before, but : I've a combo box set up with a Value List ('Row Soiurce Type : 'Value List') on a Form, and until today it was working well; no problems. Today, for some unknown reason, the 'Row Source' ellipsis has disappeared. ('Data' tab > 'Row Source')...

I've a simple form, with two fields : one is an unbound combo (named unbClaimDecision) with a Value List of Yes, No, and To be decided. The other is a bound combo (named InvalidClaim_Reason). Attached to the Before_Update event of the form, I have the VBA code below. It seems to be working up...

I've posted this in 'Modules & VBA' as essentially I think the solution is in the VBA code.. I have the very beginnings of a compensation claims database. Please see the attached. I want to be able to : Go to Form A, and click on the right-arrow buttons at the right-hand side. On clicking, I'd...

I've added an Application Icon to my database, and now I can't open the database, even in Safe Mode. Is there a way to force the database to open....long ehough for me to remove the icon. By the way, I'm not sure why the icon would cause this problem. It is a 200px x 200px jpeg. Thanks

I'm starting to try out some VBA that I haven't used before, for processing some records. But I'm getting a Run-time error '91' (Object variable or With block variable not set) error message. I've tried to resolve the problem by searching around on the www and by altering the code in various...

Apologies for the probably newbie question, but : I'm trying to work out how to populate the lines in a continous subform based on my selection from a combo box within the subform. I have a number of scenarios in which I'd like to use this method, but to pick one out : I've a continuous main...

I have a continuous form, with some text fields, some date fields, some combo boxes, and some numeric fields. I'd like to be able to filter the records, with the option to base the filtering on a number of the fields or just one or two (depending on requirements), but not via criteria set in...

Hi. Am I correct in thinking that radio buttons cannot be resized? If so, is there a workaround ? I'm using a data-entry form with a document set as the background image. I'd like to have (or somehow mimic, if I have to) the large radio buttons that appear on the document. Is there some way to...

I wonder whether someone might be able to help me with the following, please. In my Access database, I have two tables that are related to each other. tblReferences holds data on various potential reference information which may relate to my projects. tblReferences : ReferenceID [primary...

I guess ‘Queries’ is the best section to post this to. I have several thousands of lines of data which I wish to manipulate programmatically, if at all possible. I think that all of the possible permutations are summed-up by the following examples : 123 A text string 2-8 Another text string...