Search results

Could you not use ; on the log on form current action event #if not permission your code for permission then DoCmd.ShowToolbar "Ribbon", acToolbarNo end If # Hope this of use to you. Regards Ypam

Another thought . A query based on the tblclient and tbltraining with a criteria in the training session field is Null . If I have understood your question only records which have not been allocated a training session would be shown in the query . Regards Ypma

I use a command button like so ; #DoCmd.ShowToolbar "Ribbon", acToolbarNo" Another command button would be required for showing ribbon acToolbarYes I am using ac2010 hope this if of use to you. Regards Ypma

Hello locoPete99. Just a quick response to your post. Have tried putting ! eg. me! id just a thought Regards Ypma

bhelmy: I have not addressed you post directly ,but would not the following achieve the result you require ? I placed the following into another command button and it worked. #DoCmd.TransferText acExportDelim, test, "Table1", "c:\mydocuments\StartNet1.txt", _ HasfieldNames:=True# Regards Ypma

As Ranman typed . In your query add a new field for example FullName. Fullname :[Guest] & "," & [House] I have added the comma , but that is optional . You did not mention a form so have provided solution for a query Regards Ypma

Minty. Thanks again for you input I will look have a go over the weekend. Regards Bob

The Doc man . Thank you for you thoughts, I am not party to the why and wherefores so will copy your feedback and let management think about how they wish to proceed. The 20 records I mentioned go into a dialler which calls the next adviser and the clients details' pop on the screen. I get...

Thank you Minty for your positive suggestions , I will try and implement them when I fully understand how. Regards Bob

Good Morning, my question is, can records in a table be allocated to 4 different users names so each user gets an equal share? Example: I have 20 records that have been imported into the backend of the database, the dialler then calls the office and a user will process that client. All four...

Docman. thank you for your suggestion. I was not sure how to apply Trim so I used the update query that Plog provided. Regards Ypma

Plog. Thank you very much the update query , it did the trick. I had to use it on some other fields too. It begs the question how can this happen? the records concerned were all manually inputted by different users not all were effected . Regards Ypma

Hello fellow users. I require little assistance . I have a table which has a field called Last. I have tried to sort this column , but there are a number of records which will not sort . If I enter the details of record that wont sort into a new record, this record is sorted. Any pointer would...

Welkom Omewillem . Regards Ypma

Another way would be to use the thread tools and subscribe to the thread and then check later the threads you have subscribed to. Delete when not longer required. Regards Ypma

Paul, thank you very much for providing me with a solution. For some reason I thought I needed another IFF. Brain still working , but not stopping at every floor. Thanks again Bob.

Hello fellow users of Access, I require a little guidance . On my form I have two fields . Field one is a date field "DateMovedIn" Field two is an unbound field with the control source sent to :=IIf([DateMovedin]<Now()-1095,"Longer than 3 Years","Less than 3 Years") Works fine, but if the...

Tieval. Worked on the database that I am working thank you again.

Tieval, fantastic will now use that code in my module and give feed back Many thank Ypma

Tieval ,thank you for your input. Saving it did create a SpecificationName, so far so good , but I could not save it any further suggestions ? Ypma