No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
3 Posted Topics
You may use Mid(function) as below: Suppose your number is in A1, in A2 or the last cell of the row, input formula = Mid(A1,0,4), then on the next cell = (A1,5,4) like that till last digit. Then next cell would contain formula = A2&"-"&A3&"-"&A4&"" etc. If you can send …
THis is easily solved by running a query containing all fields you want in the form and designing the form as tabbed. After designing the query, in the query, make all joins from primary table to other tables as right joins. A sample data base i can send you if …
Dear John First make a form with two date fields Lets call first one as Firstdate and second one as Seconddate Go to Designview of Form On property sheet of the Seconddate - at Data tab, Change "Enabled" into "No" and "Locked" to "Yes" On property sheet of the Firstdate …
The End.