Search results

I have few Ms Access 2016 forms and after few minutes, certain forms cannot display out all objects on the said forms. For example, a form contains 2 combo boxes, 5 text boxes and 3 buttons. Only 1 combo box and 1 text box are displayed out. I believe something to do with the memory. I am...

I am writing a software to display out 10 data at one time onto LCD TV before the next 10 data is replacing the earlier 10 records. To do this, I am using a recordset to move at the back and recordset is moved next through 10 times of looping. Recordset is then bookmarked and linked back to...

I am writing a software to display out 10 data at one time onto LCD TV before the next 10 data is replacing the earlier 10 records. To do this, I am using a recordset to move at the back and recordset is moved next through 10 times of looping. Recordset is then bookmarked and linked back to...

What i know is MS Access, I can a) Form use the Me.Recordset.MoveNext to move to next record. However, end user is looking something like every 3 minutes, the first page data is moving upwards slowly before new set of data is replacing the existing one. There is a animation to show the...

I am building an airport arrival and departure board system. Is anyone know where to download or plug in the said component ? The component (or table) has the feature to move up existing data before it is replaced by with NEW data I have attached a picture to illustrate the scenario

After I migrate my Access 2003 system to the platform 2016, this control show missing. Not too sure if anyone know how to add in back the progress bar in the Ms Access 2016 ?

How to write codes to hide the 2 menu bars or ribbons on the form onload event ? (You can click the attachment below to understand better) Presently I have written "DoCmd.ShowToolbar "Ribbon", acToolbarNo" at Form onload event

Conditional formatting can be used to color a text box based on value How about to visible and invisible a text box based on value?

I have created a continuous Access form. There are total 8 bounded text boxes on the form. There is a text box show either OK or NO value and suppose got around 30 rows of data on the form. How to color the text box with different color. For example, OK indicate as Green color and NO indicate...

I got the answer from http://bytes.com/topic/access/answers/211950-order-events-delete-record-subform

I have a main form call frmARSystem. On top of this form, there is one text box [txtPrice] and one sub form [subForm_ARSystem] When user press the delete KEY and remove one row of data in the subForm_ARSystem, I want the txtPrice on the main form ARSystem to be updated accordingly. I have...

There are more than 300 queries in my MDB. Any quick way to search whether a sub-query is in use or not as the sub-query may appear in other main query.

I have found the solution. After added the ODBC connection string into the query V_Invoice_DO_Detail, the problem resolved. Nothing to be changed or done in the VBA codes. TQ everyone at here.

1) you want an adodb connection but are questioning a dao method Answer I am not asking anything on DAO since my first post, you may have mis-interperted somwhere. Let come to the basic, i m asking how can I overcome the error message after replacing the 2 MS Access tables with the 2 SQL...

1) Which code made you say I am mixing ? I am fully use the ADODB from the beginning of the code till the end as shown on the above. I don't get you at all. Fyi, before the 2 tables are migrated into SQL Server platform from the MS Access platform, I do not have problem in calling the...

Appreciate if anyone can help in resolving the codes by inserting some codes to enhance or fix the existing codes fyi, dim rsTemp as ADODB.Recordset

1. The Access DB contains a lot of other ADODB codes inside. In order to standardize the programming method, I have to use ADODB to call up the QueryA 2. However, when I try to call the QueryA by using the ADODB, error message will be prompted out saying "connection xxxx failed!!!", properly...

There are 2 linked tables, TableA and TableB, from the SQL Server in my Access DB. These 2 tables are linked up through a query called, QueryA, for example. I need to write a VBA codes in the MS Access by using the ADODB to open QueryA . How to write the VBA by using the ADODB ?

Can anyone suggest how to resolve the problem ?

I need to write VBA to retrieve 2 files and print out in one single output A4 paper size. Can anyone assist on this matter ?