Search results

I think I've cracked it. Have managed to get it working for OfficeID using the following SQL Statement: UPDATE tblBreakdown SET tblBreakdown.OfficeID = [Forms]![frmMailboxAssignment]![cboOffice] WHERE ((([Forms]![frmMailboxAssignment]![cboName])=[tblBreakdown]![StaffID])); Just need to get it...

Hi Jdraw, Thanks for the reply. What I'm trying to accomplish is a database where I can assign a staffs email address to an office and what type of mailbox it is so I can break it down later to calculate the monthly cost for that office. The tblBreakdown is where I will store all the ID's for...

Hi there, I was wondering what would be the best way of updating only a specific row in a table with new data from a form combobox? Currently I have a query that updates the OfficeID and MailboxID in tblBreakdown to what ever has been selected in the corresponding comboboxes on...

Thanks for your help JHB. Kind regards, Dom

Hi Minty, That is perfect, thank you. There was me thinking its not complicated enough being the issue. Kind regards, Dom

Hi JHB, Thank you for your reply. Please find attached my database. Many Thanks, Dom

Hi Ranman, Thanks for your reply. I have deleted the "acViewNormal, acAdd" part of the code but it still doesn't pick up any of the ID numbers. I just get a message you are about to append 0 row(s).

Hi There, I am trying to create a very simple append query that takes the primary ID's from each table (tblName, tblOffices and tblMailbox) and adds them to the tblBreakdown dependent on the selected data in the three comboboxes (cboName, cboOffice and cboMailbox) on frmMailboxAssignment. What...

Thanks Smig, That didn't seem to work for me. Got an error saying "Compile error: Method or data member not found." This is being flagged up in the mainform as it can't find the textbox on the subform. Would you say this is the best method of doing this, using a value greater than 0 to change...

Hi there, I am trying to get a subform to be hidden when the value of a textbox (txtAllocationID) is empty but when a ID number appears I would like it to become visible again. This is what I have tried so far but doesn't seem to work: Private Sub txtAllocationID_AfterUpdate() If...

Sorted the unique value. I just needed to put 'DISTINCT' after 'SELECT' so it reads like this: strSource = "SELECT DISTINCT Model " & _

Yes, I did look at the sample db and got mine working; thank you. I just have a couple of questions. With the criteria of the query you have chosen 'CA' and not 'NV'. Why is this? Is there any difference in which you use. Secondly my second combo won't display only unique values even though I...

Where would I put the second options code. Would it go under an after update of the first combobox? Thanks

I have two comboboxes on my form one 'cboMake' and the other 'cboModel'. Both of their values are stored in individual columns ('Make' and 'Model') in the same table 'tblStock'. What I would like to achieve is when I select a value from 'cboMake' that 'cboModel' will filter it's data values to...

Never mind I have got it going. Thanks both for all of your help.

No it would be just 'Item'. I changed it to the following: CurrentDb.Execute "INSERT INTO tblTest (Item) VALUES ('" & Me.txtItem & "')" Now when I click add it doesn't ping up with any errors but instead doesn't add anything to the table. See attached screen shots.

Sorry my bad. Should of seen that. I have corrected that and now get "Run-time error '3127': The INSERT INTO statement contains the following unknown field name: 'txtItem'. Make sure you have typed the name correctly, and try the operation again.

I tried your code pr2-eugin but got a "Run-time error '424': Object required". I am new to access so more than likely I have entered part of your code that should of been edited out but can't see what so could you help me please. Private Sub btnAdd_Click() Dim iCtr As Integer For iCtr...

Apologies I might not of made this clear. This isn't a retail shop stock table but instead an office stock table. The scenario would be a member of staff phones up and says their keyboard is not working so they read out the unique stockID labelled on the keyboard. I then search for this stockID...

Hi pr2-eugin, Basically I want a list of all the stock I have and to be able to search for a specific item to see who it has been allocated to and when it was purchased etc. and this is why they all need a unique stockID even if they are the same item. So to save time I would like to enter an...