Search results

any luck with mdb file?

The sample data in mdb

When I created button command and event on click still showing same message

Private Sub Combo12_AfterUpdate()

showing error: Method or data member not found

If exisitng do nothing

How to check data using code. What I want to do is: load data from form: trailer, trailer_date, status and required date, insert date to table vection but I need chceck first to avoid duplication in table. Somting like insert if trailer and trailer_date not exising in table. Could you help...

Thanks you correct, you right, but is possible use the where clausle?

Hi I got problem with insert event in access form. I try use DoCmd.SetWarnings False DoCmd.RunSQL "insert into vection ([trailer], [status], [required_date]) Values ([Forms]![Form1]![trailer], 'U', [Forms]![Form1]![req_date]) where [Forms]![Form1]![req_date] not in (select distinct...

Please advise

I using access 2003. If not vba maybe access qury? I need created event for combo after update

Hi I wrote insert query in t-sql but I need that query implement as vba script in access insert into #vttrailerm (trailer, trailer_date) select trailer_ref, Convert(char(6), required_date, 12) from #vttpstatm S where not exists (select * from #vttrailerm where Convert(datetime, '20' +...

I added event in Dahsbord form in FormOpen Becouse like I said buttons exisint in dashboard form. (If Forms!Dashboard.XH!Collection.Value = "Name1" Then Me.Command1.Enabled = True Else Me.Command1.Enabled = False End If)

Sorry I thing you not understnad me. I got subform with continuous rows, and the main form - dashboard- single form. I imported - linked subform into dashboard thats mean in single form I got subform (continuous) now in single form I created 3 buttons and all disable. When in subform exisitng...

I want disable or enable in dashboard form using subform for criteria

Hi I got query with specific criteria query returning list like: Name 1 Name 2 Name 3 I loading query into Continuous Form 'sub1' Next I creating subform in dashboard form for each name I got button, default is Me.Command1.Enable = False Me.Command3.Enable = False Me.Command3.Enable =...

Hi I got form with calculated fields next step I created button which will be posted into table data from 6 fields What I want to do is create thick box and if thick box is not selected for one field and selected for 5 other fields after pressed button script will be posted just 5 fields I...

Still not working but strange, example I printed off 3 pages, top margin on first 8 cm, on second page margin is 6,5cm and on third page 5 cm....

Sorry, I put some sample data

right, in table I will be insert new record, default filed content for new entries will be 'A' then users using form will be allow record to confirm 'C' and pass to next stage in process, Now in table for one day will be showing about 10 orders and I want confirm - update status field using...