Search results

Hi, apologies for acknowledging before. I tried that and couldn't get it to work. However, that may be because I was doing it wrong. My Access skills are the more basic side of intermediate!

Hi all, Apologies for bumping this thread but due to COVID the requirement was put on hold. But now it is back again and I still haven't figured out how to do this! I can give some more detailed background on what I am trying to do and why I have to do it. The backend database resides in...

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

Thanks. The current format and modelling for the resource assignment works, I just don't know how to automate it using a query, as my Access skills aren't that strong. Worst comes to the worst I can probably muster something up in Excel using IF and LOOKUPS, but I'd much rather just get the...

Thanks for the prompt and regular responses, they're much appreciated! All the criteria is set out in the OP but I'll try and rephrase the requirements below. There are three types of distinct resources. Logistics - Being there for the arrival of hardware, unboxing, powering on and making...

Unfortunately I can't send the DB due to the customer data in it. Is there any easy way to insert a table on this forum? I notice the example in my OP the formatting got screwed up. I've attached a screenshot of an example as to what I am trying to achieve, using the ratios set out in the OP.

Hi, Thanks for the response. Currently I export the table from Access into Excel, manually work out the resourcing requirements and then import back into Access. I know exactly how I need the resourcing to work, I just can't figure out what queries I need to make it happen!

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

No way to do it without having to resort to VBA (which I know very little about!) then! I'll have a play around and see what I can do. Cheers!

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

Thanks, didn't even know the extra Macro options were there! That worked.

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

Perfect Mark. Thanks very much! You've actually inspired me to start learning VBA in depth because it really does open up what you can do with an Access database.

The error occurs at .MoveLast within the code. Private Sub Form_Current() Dim count As Long With Me.RecordsetClone 'here you force the clone to load all it's records .MoveLast 'and then call .RecordCount count = .RecordCount End With If Me.NewRecord Then...

Hi Mark, So I realise now I wasn't clear in my previous post. The search box only returns that error message if the search criteria can't match anything in the database. The search box is just an apply filter macro where the condition is "[FullName] Like "*" &...

OK, so I may need to post this in a new thread as the problem is solved but since adding the code it's created a new problem! Now if I use the search box I have to find a record I get the "No Current Record: Run-time Error: 3021" pop up. If I revert back to the old code it doesn't. Is that...

I don't know a great deal about VBA so am trying to work out exactly what your code above did but it definitely solved my issue so thank you very much!

It is. It works fine on all other forms except this one so I think it is a filter that has saved somehow but I certainly can't find any reference to it anywhere!

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