Search results

Hi, Sorry I can't get this to work properly, currently what I have is the manual rate disabled, but when I select a Provider Rate of 0, the manual rate box does not change to be enabled. I think it might be because my Provider Rate is a combo box, which is bound to the ProviderRateID...

Hi, thanks for this, and I'm about to ask a really daft question, so appologies for this. I already have something in my On Current event , so how do I got about adding something else, and do I literaly just type Set 'ManualRate' enabled = False As I have tried typing this into my On Current...

Hi, i have a form with cascading combo boxes, all of which are set to requery the combo boxes below, however i have one which is Service SubType, and it should requery Provider and Subjective, however it only clears the Provider and the previously selected subjective is still there, when you...

Hi, I have a form, and on the form there is a Provider Rate which is a combo box, if the user select a zero rate, then it has the description please enter manual rate in box below. There is another box which the user can enter a manual rate. Can someone suggest how I can limit entry into...

Thank you. However I thought I would mention that I have tested all the navigation panes, and discovered that when the the buttons stop working, if I right click my mouse that seems to fix the problem. I'm still not sure why this would be though.

hi, I have record navigation control buttons on my form, but if I am at the First Record, I don't want the Previous button to be visible, and equaly if I am at the last record I don't want the Next button to be visible. Could someone let me know how you go about doing this please? thanks...

Hi, thanks for your reply. Could you give me some pointers on how I would go about compiling the code please?

Hi, I have a form which is a single form with a subform. The form shows commitments and the subform shows related income commitments. They are linked through the CommitmentID. On the Main form there is a tick box which should be ticked if the commitment has been cancelled. The backgorund...

Hi, It has been built in Access 2003. It's still in build mode, in that in two weeks it will be split into a front end and back end, with the back end on a server and the front end as a short cut on users PC's. Currently it is sitting on my desk top. I just worry that this issue will...

Hi, I have created Forms to use as navigation panes, and have inserted command buttons to go between the navigation panes or to open the forms for data input etc. My main form is attached to Startup part of my database. Once I click on a button and it opens another form, I have a bit code...

Hi, Yes, I would download the data with the key from Access and do a look a lookup from the excel file, to add the key. Then we would then just keep uploading the excel file with the key where it already existed and append the details of the commitment.

Hi, thanks for your reply, that sounds like something I woudl want, however i have no idea how to go about actualy doing that, and when we come to doing this for real, I will have a front end and back databse, and I woudl ahve to attach all the processes to buttons or something as the user...

Hi, I need some help and advise please. I have a commitment table in my database, and normally people will input commitments through a form. However each month I will have a flat file upload from excel directly into the Commitment Table, these will be up to 1500 lines. (they are downloads...

Hi, thanks for the advise, unfortunately I don't have time to change my database, as I now need it to be up and running for testing. This is definately something I will look at should I ever build another one though. Also I assume it will still work using the table level lookups?

I fixed it, I took the ID out of the table, as the person's name is unique anyway, and it worked. Thank you very much for your help. I do have one last wquestion on this, and that is that the lookup needs to look up three different columns, as there is a finance Assistant, Finance...

Sorry you saying that has just made me realise that the Finance Asistance was a lookup field which has 2 columns and the first column is the bound one as that is the ID from the Finance Assistant table but what I see is that actual name which is column 2 in the lookup. Not sure how I look...

Hi, I am now getting a Data Type Mismatch in criteria expression, I;ve copied the code below. I'm just not sure whta it wrong wtith it. Private Sub cmbCostCentre_BeforeUpdate(Cancel As Integer) If IsNull(DLookup("[cmbCostCentre]", "tblCostCentre", "FinanceAssistant = '" & CurrentUser() &...

Hi, sorry but I'm now getting an error message saying that there is a Syntax Error in query expression 'Finance Assistant = 'Admin', I've put that line of my code below, not sure what I've done wrong. If IsNull (DLookup("[cmbCostCentre]","tblCostCentre","FinanceAssistant = ' " & CurrentUser()...

Hi, Thanks for your reply, however within the Dlookpu part there are three different columns that need to be looked up, how do I manage that, I'm thinking that it could be: If IsNull (DLookup(...,..,.)) OR (DLookup(...,...,...)) OR (DLookup(...,...,..)) Then .... Would that be right?

Hi, I have a form called frmCommitments, where each user will enter commitments. Each user has specific Cost Centres that they work on. This is noted within the Cost Centre table, within 3 different columns, Finance Analyst, Finance Technician and Finance Assistant. When the user (who...