Search results

Hi Gemma, i ended up in this situation since i was not capable of coding a split form properly. Yes they are linked to the same table. The continoius form has record selectors and the single form is relayed to the continous form via an unbound textbox. I click on the record selector and the...

Gentlemen, thank you for your effort. I will look into the timestamp issue.. Thanks!

This is very valuble information Galax..i iwll clean up a database and see if i can post it.. Thanks a lot for all help!

No Worries Rural, your intentions are much appricaited. :-)

"-You can't save the record at this time Access may have ancountererd an error while trying to svae the record If you close this object now, the data changes you made may be lost Do you want to close the database anyway "... The back end is on a SQL 2008.. Thanks!

Hi all, I am encountering this issue when wanting to save edits...this is the setup Unbounded Form A including two forms and one text-relay control. Bounded sub form “records due today”. Source Query Today. Related tables 1 and 2. The query includes date criteria. Data displayed in continuous...

Thanks you for the tip.. I have also encountered the limitations of a Split Form, but as in all stories there are two sides of the coin :-)..if i proceed witht he form/subform prinicple..how can i incorporate the fantastic feature of expanding the Singel View tile of the Split form in a...

Hi all, i would appriciate some advice in the following issue. Split Form A is based on a query. back end on SQL. I choose to make the split form editable..the user can edit in the "single form" part. There is code running in the "on current" event of the form in order to synchronise a...

Thanks for the explenation :-)

Sorry for my late reply, i thank you both for most valuable suggestions. I choose the method of referring to the open form in the popup form on current event (this since the backend is in SQL and seems tthat on the load event is premature).. Once again thanks you for you valuble time!

Nope..i will try to figure this one out in one way or other..must be related to the SQL..Thanks anyways!

Thanks you BobLarsson..as always.. :) Unfortunately this do not cure the issue were the related form opens and prompts for a new record (New)...

Hi again, i am using below code to open a form with related record. However, the form opens but prompts for a new record.. why is it that? Access 2007 frontend / SQL 2008 backend. ID is the primary key Fruits is the form i want to open Dim stDocName As String Dim stLinkCriteria As String...

Hi all, I am using a popup form for entering new records. On the forms “on Load “ event I use the following code, DoCmd.GoToRecord , , acNewRec..but once the forms is open all controls are populated with “#Deleted”. Front end Access 2007, backend SQL 2008. Do i really need to create a command...

Hi all, Table 1 and 2 are related, primary keys are set and defined. However, when a create a form based on Table 1 and include a subform based on table 2, the subform is not visible..and i cannot create any record to this. Front end Access 2007, backend MS SQL 2008.. What am i doing wrong...

:-) i must be the most stup... guy around..i did not assign the Identity Specification of the Primary key..and yes boblarsson..i just realized that to the contrary of Access db..the SQL assigns this value on the update of the record..i.e,,all fields needs to allow null values... i will get a...

Yes, primary key is defined..i just dont get it.. "I have an issue with GoTorecord,,,New, on a forms onload event.." should assign a new ID

but unfortuantly i can not save the record since i recieve a an Error message "May entoundered an error"..my backend is on SQL...

..strange enough..i receive the ID when i move out of focuse from the form..

Yes i can type in a value, but the form will not save those values... Perhaps its best to create a new form and then include the Form B as a subform... i was hoping not to do this..