Search results

I have a stand alone PC that is connected to the local network. I have an access database that I use for running some update tasks over night. Basically I open the database, set a time for a form onTimer event to trigger and leave it running. Then I lock the desktop and it will run every night...

I have a back-end / multiple front-end database set up. I need to regularly update the BE with data from an external source. The tables in the external source are linked through SQL server. Updating directly from the external tables doesn’t really work as it is extremely slow and the tables...

Hi All, I have a backend database that in itself doesn't grow in file size very much with normal use. However within the database is a table that updates overnight with a snapshot of various production information taken from an external source. The update runs from a separate database and...

Ok, I am quite experienced with database, forms, vba etc. but have never come across this issue before. I have a form a user opens and enters data. When the user has finished entering data the user will press a command button the will print a report. This is hard coded using VBA, so I know the...

I'm trying to sort a multiple column listbox. The listbox is a value list. I've found some code (listed below) which may work but it was written for Excel and I get compile errors when trying to use the code as I don't think Access recognises MSForms.listbox & the .list property Can anyone...

Hi All, I have 2 listboxes (set to value list) which I transfer data between. After I move a record from ListboxA to ListboxB for example, I want to keep the selection on the next record down in ListboxA. This isn't a problem as I can use Me.ListBoxA.Selected(i) = True where (i) is the index...

Hi All, I have a combo box which is used to find and select records in a continuous form. I'm to figure out just how to populate the combo box with records in after a filter has been applied to the form, so the combo box only shows the records being displayed and not all the records. I am...

I'm using the DOA.Recordset method to open a recordset based on a SQL statement. (SELECT * FROM ....) I then use 'If Not (rst.EOF and rst.BOF) then' ... to check if the recordset is populated. This normally works fine except when I use some sort of Group by, Max etc. in the SQL statement. In...

Hi all :) I have a DB set up to receive data from a scanner through a virtual COM port. I manipulate the received scan data in VBA before writing the result to various tables. For certain scans, I'd like the user to confirm the scanned barcodes by scanning it again within the a certain time...

I have a bar code scanner I can set to act as a virtual COM port and I'd like to set up a connection in my DB to the scanner so the DB will pick up any bar codes scanned. This is my first try and doing anything like this! So was wondering if any kind souls might be able to help me set this up...

I wanted to use Application.Onkey within an vba procedure but it doesn't recognise it as a valid method. Is there a specific reference I need to point to? I'm using Office 365 on windows 10, so assume I'm using the latest version of MS Access. Thanks

I have a database on a stand alone PC that is used solely for capturing bar code reads from a scanner. In order for the result of the scan to be captured and stored in the database, the focus needs to remain on the open form. So I am looking for any tips or tricks that would stop some curious...

Hi, I am having a problem running a make table query which is based on the same tables that I am using in a sub form. Basically, the user selects certain records in the subform (which is in datasheet mode) using a check box, then once selected he hits a command button where there is some code...

Hi, I am just wondering if there is a rule of thumb about when to split the tables of a database and when to keep the tables intact? I have a database I need to put on a server. Only one user will access the forms, but many users will need to query the data. So in this case I thought it best to...

I have a continuous form who's record source us a query I use for summarising data in the form detail. In the form header there are some controls for the user to add new data. Usually this opens a pop up form, where the user will add the new data then I updates the underlying tables using code...

Ok, someone is having a good laugh at my expense! And probably others. I started a new thread in which it took me a bit of time, around 5 minutes to think about what I wanted to put. The post itself was probably only a few paragraphs long. I go to press on submit and guess what, the site asks...

Hi, I have a form with a control for the user to enter some data and then two command buttons 'OK' and 'Cancel' For the OnExit event in the control I have a procedure that check the user input and if incorrect, opens a message box with an error message asking the user to correct the data. It...

I have a query where I want to add sequential counting to all items that are part of a group. I have grouped the query on MaterialCode and want to add a sequencial counter for all orders that have been assigened to a materialcode For Example: Key MaterialCode Order Counter abc1...

In my report have a control that works out a ratio for each record compared to the sum of all records for a given field name in a table. So for example of the field may be 'output' and the control in form calculates the ratio of each individual 'output' as a ratio of the total for 'output'. I...

Not sure how to best explain this but here goes: Imagine a production environment where there are various machines. A product can start its journey on a 'production run' from any one of those machines and take a number of different routes (process steps) through the production environment...