Search results

Hello, In the design view select both tables and Link the fields you need to Update from/to. In the field put 'YourRequiredField' In 'The Update To:' you put something like [TableFrom]![YourRequiredField] This will update TableTo with TableFrom's data. Hope that makes sense. Regards.

Like [Enter name of country:] & "*" Or Like [Enter name of country:] Where the user puts in the *'s themselves.

Hi, I'm only in for 2 minutes so I don't have the rules yet. However 365 is the calculation, regardless of leap years. This is the first thing I queried way back in Jan last year. As for service I believe that 1 full leap year, 366 days, equates to 1 year 1 day previous service. This is in...

Hi, thanks for getting back to me, and no harm done. I have new information regarding this, but, I found the current Excel calculator on my works intranet at 21:55 5 minutes before I left. When I'm in today I'll extract the rules they've put down as formulas. They seem a bit odd regarding...

Hello, I think you would be far better off re-organising your data. You would benefit more from a table designed as follows: CostID - PK TypeID - Long Int Amount Date You would have more flexiblity later on down the line, i.e. you might need to add another CostType to your table and...

Thank you for your comments, However, you've hit a nerve, so apologies if what comes next is out of line. I disagree that it is a "full scale programming gig", what is a 'gig' anyway, do you mean project I wonder. This is actually 1 question relating to a the huge project that is already in...

The limit is 256 and can not be changed. That a lot of columns? do you need that many? I'm assuming it's for visual purposes, can you not break it down to more managable chunks months, area etc.

Sorry all, Just thought of something else, An employee may have previous service. I can add a table which has this in days but it will need to be calculated in. SO, Jim used to work for us from 1st Nov 88 - 22nd Jul 92. His service is 1360 days, this can be stored in a seperate table. BUT...

All, OK, I'll give this a go and if I leave anything out please post back with questions. I've been putting this on hold for oooo 8 months. The basics are that I need to calculate Employee holidays based on LOTS of factors. Here are the key elements: tbl_EmployeeMain 1) StartDate - the date...

What do you mean if I select Camero from cbo2 nothiong should happen? You need to set up a query which will be the Control Source of your Pop-up Form. In it you can set the criteria to those Comboboxes, Something like [Forms]![MainFrom]![cboName] [Forms]![MainForm]![cboCar]

Use your primary key in the Main table as the link (which should be a given) and set the Child table MainTableID to Indexed Yes (No Duplicates) You can then goto the relationships and when you create it 'Enforce Referential Integrity' you will see 1 to 1

Please see attched, no code just a Query, should be what you are looking for as a basic. The records get saved but not the ExpiryDate, this generated every time.

As I have mentioned you don't want to be storing the value: If you need more pointers please ask, but don't store the value, it's not needed, ANYWHERE in a table.

Hi, as has been mentioned, you don't need this field in your table at all, also mentioned, delete it. Use: DateAdd("m",30,[StartDate]) > Date() <--- whatever date you are testing agianst. As the Criteria in a query.

Who is deleting the records? you haven't said where this occurs. I wouls n't recommend deleting any of your data I don't see why it's needed. You can Filter the data the a/p uses on the form, they will type in the order number from the receptionist and have only that record. Or am I missing...

Also, are they Updating the records or Deleting the records then adding a new one????? Sounds like you should be linking your Form to a Query of the table not the actual table, you'll have more control then. Using Me.Requery will refresh the query for them.

Best thing is to delete then add the Subform again, should be ok after that.

I'm unsure of Recalc issues, but have you tried putting them back in one by one. You can then find the culprit post the Code/Formula here for a clearer picture of what is happening. Regards,

If you set up the Parent/Child links correctly the Subforms will update when you Requery the main form. To do this you need the same field on all forms. e.g. RecordID The code is just : Private Sub Combo22_AfterUpdate() ' Find the record that matches the control. Dim rs As Object Set rs =...

I'm no expert with code but: DoCmd.GoToRecord , , acNewRec will bring up a new (blank) record on the form. Also, and has been pointed out to you, the last line should be Me.Requery Replace one with the other.