Search results

Hi All, I'm trying to put together a form to an AzureSQL database (not mine) and am struggling on some location combos. The table design is that only one parent appears on the relevant table. For example, the Country table has idContinent on it. The City table has idCountry but does not have...

Hi All, I have a really big ask for some help! I want to automate a resource plan against a forecast schedule. Specific details are the forecast is how many computers are to be deployed on a given day and how many people I need to make that happen over a period of time. The reason for the...

Does anyone know if there is a way to change the default way a field is selected in a form so that it doesn't highlight all the text when you tab? I have the standard black text on a white background but when the whole field is highlighted it looks ugly and I think is quite difficult to read...

Hi, I have a temporary table within my access database. I have a macro button that makes the table (thus deleting the old one in the process) and then appends information from three other queries to it. I want to stop the standard warning message from coming up. The message I get is below...

Hi all, I have a custom record counter on a form using the below code: Private Sub Form_Current() If Me.NewRecord Then Me.lblRecordCounter.Caption = _ "Record " & Me.CurrentRecord & " of " & Me.Recordset.RecordCount + 1 Else Me.lblRecordCounter.Caption = _...

All, Do you know if there is any way on a table that I can have a unique identifier over two fields? E.g. I have a login ID and a Domain field in a table with sample data below. Login Domain John Test Jane Test Fred Live John Live The login names need to be unique to the...

Hi all, I've been handed a spread sheet that is an output of information captured by a script that captures network drives attached to a user's profile. An example of the output, for one user, is below: K: = \\Server01\MARKETING ; P: = \\Server01\APPLICATIONS ; R: = \\Server02\ENGINEERING ; S...

Hi guys, I'm new to the forum and to Access. I don't know any VBA yet. I have a problem with a cascading form, which writes back to another table. The scenario is: There are three tables. Users, Departments & SubDepartments. Each table has an Autonumber set as the primary key...