Search results

Hey guys, hoping someone can help. I have a field (string/varchar) in a table, called carton_number that stores carton numbers in various ways. 1) They could be single cartons so 2 or 10 or 25 2) They can be comma separated to indicate multiple cartons so 1,2,3,4,5 or 10,20,30 3) They can be...

So there are a thousand threads on how to use SelStart but I'm so far unable to find one that tells me how to make it work where a combo box has an input mask. I'm using Access 365. My combo box is called cbo_nsn_filter. My onClick event code is: Private Sub cbo_nsn_filter_Click()...

I'm using the TransferSpreadsheet function to output a query to a spreadsheet. The output works great except the ordering of the columns isn't matching the order specified in the saved query. Does anyone know of a way to maintain the correct order? To give you an example, I expect a query to be...

Morning guys, This is something of a general VBA/query/structure question as I'm interested to hear how other people approach this issue. When you're writing a typical VBA sub which requires you to do multiple queries, how do you keep your code well structured, organised, clean and tidy...

Morning everyone. I have a complex query that's being generated by code in VBA. It contains various fields that are supposed to be output to show progress, for example: Despatched: 50/50 Delivered: 50/50 Approved: 40/50 The problem is, and even though I'm escaping the characters, the slashes...

Is it possible to have a control - formatted as a date - have its datepicker popup when a separate button is pressed? Basically I want to put a date field on a form with a calendar icon next to it. When the calendar icon/button is clicked I want the datepicker to appear. I know you can just...

I have a form whose recordsource is updated on the AfterUpdate event of a control on the form. A query is built according to the value chosen in the form and the form's recordsource requeried accordingly. One of the fields returned by the query is a date field (promised_date). A bound control...

We have an Access database we have been using fine for years without any issues. The database is an MDB front-end connected to a MySQL database backend. We recently moved to Office 365 with the database running on an Azure server and users connecting in using Microsoft Remote Desktop. Quite...

Hey guys. Our Access DB has a button that allows users to save a PDF of the report they're working on, to their desktop. We are moving our Access Database online to be run from an Azure Virtual Machine, but this button now saves the report to the VM's desktop instead of the local desktop...

We use an internally-developed database system that utilises a MySQL back-end running from a server running XAMPP, connected to a Microsoft Access front-end using ODBC that runs locally from every user's computer. We are looking to move away from the typical Microsoft Server 2012 Active...