Search results

I have recently created an Access database for an acquaintance, sending him the 'working-copy' (.accdb format) file, and instructing him on splitting the database into 'back-end' and 'front-end'. It seems he's been able to create the back-end (‘Database Tools’ --> ‘Move Data’ section -->...

On an Access form, I have an unbound 'unbCalendarUpdates_FromDate' field, an unbound 'unbCalendarUpdates_ToDate' field, and a 'btnCalendarUpdates' button. On the 'On Click' Event for the button, I have the following VBA code. What I'm trying to do is to delete all Appointments (lying within a...

I thought it best to post this in 'Forms' rather than 'Modules & VBA'. In the past (in relation to other databases I've worked on) and again in the last couple of days (for the one I'm working on now), I've conducted research around making formatting etc changes to specific fields in specific...

Hi. I wonder whether someone could advise me on the following, please. I recently encountered the MSysDb error-message on an Access 2021 database I've been developing. "The Microsoft Access database engine could not find the object 'MSysDb'. Make sure the object exists and that you spell its...

I wonder whether any guidance can be offered up re the following, please. I have a tab control set within a main form, and on the one tab that I've created so far (to introduce others later), I have a subform. Also on the main form (within the Form Header), I have a couple so far (to introduce...

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...