Search results

Hi my understanding of acsaveno is to save the form but nothing to do with the data on the form. thanks

Hello Is there code which would close the form without recording it in table or specific fields? something like DoCmd.close acform "Form" acdontsave Thanks

yep CancelEvent is bit uselless there. Quite right I don't want to duplicate the data that is why I have 2 tables. First Visitors detail- Name, Surname, DOB etc Second Visits details- Date, Time In, Out etc, On the form there are fields from bough tables and therefore if the visitor exists it...

Hi Guys I have code whch is working fine to the point I need to close this form. It checks if the record exist in "Visitors Book - Personal" and if it doesn't it just enter it with the visit detail to "Visitors Book - Visits" and closes. Now is there a way that if the record exists it does...

Brilliant Thanks very much

Hmm not sure I can run: ?DLookup("ID", "[Visitors Book - Personal]", "[First Name] = '" & Forms![VisitorsBookIn]![First Name] & "'") and ?DLookup("ID", "[Visitors Book - Personal]", "[Surname] = '" & Forms![VisitorsBookIn]![surname] & "'") separeted but when putted together : as you said...

Hi guys Could somebody help me to find the error in this syntax, please. DLookup("[ID]", "Visitors Book - Personal", "[First Name] ='" & Forms![VisitorsBookIn]![First Name] & "'" AND "[Surname] ='" & Forms![VisitorsBookIn]![Surname] & "'" ) It should look for the "ID" of a user "First and...

I have made it work on the sample. works fine "ID" link on "table1" to "Unique No" on "table2". The problem I am facing now is it doesn't work on my real one which is linked to sharepoint. It could be because the field is not idexed, but sharepoint won't let me use another indexed field than...

Hi Thanks for looking at this. Sorry I have been very busy not just with access. But here is the sample what I mean. Thanks again

Hello I have posted thread yesterday called empty form. So i have checked few thinks. Let clarify some details: Tables are linked to sharepoint. Form is bound to query. The qery is bound to two tables. Now if i do relations to ID on both tables and create form it works but showes all the...

Re: Empty Form It is quite big about 5MB and I have to go now. but Thanks very much for your help for tonight

Re: Empty Form I have checked and designed new query and new form but it was still showing the previous records. There is no code to open the form either. Than I have deleted all old records and made new form which in design mode looks ok but than in form view is header bit the form detail...

Re: Empty Form It is set as Yes, but I need user to add deta, just not to see the previous. Thanks

Empty Form Hello I have Form bound to query. The query is bound to two tables. It works fine apart it showes all the entries. It is pop-up form. So is there a way it always open clean? Thanks

Hi Yes it is, but is there a way to link it if it wouldn't be. Thanks

Sorry but not sure what stNoExist mean. Thanks

Hello I have working code, but i need bit tweek. So There is a table "Visitors Book - Personal", with Fields: "ID","Unique Code","Surname","First Name",etc Now! When I press ENTER button it check if exists, ( It Works ), on the end is little code which takes ID and changes to "Unique Code"...

Great one I know drop down would make it easy but It is for touch screen so probably easier to use my way. Thanks

Hello I have form with text box called "Month" I have button "Jan";"Feb" etc. I could do with when I press "Jan" button it will focuse on the "Month" textbox and enters text "January" in the text box. This should be simple but I not able to figure it out Thanks very much

Hello Could somebody help me. I have 2 tables. First called "Details" with visitors details and Second called "Visits" with visit deatail. There is the Form where I put all the datails. ( Name, address, Company, Date, Time ) I need the the code which will search the the "Details" table...