Search results

Hi All... I have many eports in my db. Some to be printed in Portrait while others in Landscape. When I go to Option and adjust the margins and all necessary spaces. I set a landscape to one report. But when I close db and re open it again, it returns to Portrait and not Landscape.... Any...

I'll have a look at the topic. Thanks a lot David R for all your kind help. Yours

Actually, I set the Date Field in my form to Date(). My PostOffice Field is a LookUp Field picking a data from other table with restriction: Limit To List : Yes. So, when I open a form to enter a new data, Today's date is selected, and I have to select the office name from the list only. Here...

'Hit OK and then escape' yes means that I Click OK and then Press Esc key. If I do so, it accepts my entry even if it's duplicated.

Sometimes I feel myself confident of writing the codes in Access, while when I stuck, I feel that I'm so stupid... Ok Dave, it works fine. I'm very thankful for all your help. But then, if I enter same PostOffice Name, MsgBox Appear and then I have another MsgBox says: The value in the field or...

Yes Dave I named my field as OrderDate and changed it in the code as well. Still it gives me same error.

Hi David R, May I send you my db

Hi David R, Sorry to disturb you but still my code is not working, and further seek your help. My FieldName in Query is Date and PostOffice. In Form, the control name is txtDate and txtPostOffice. PostOffice is Text and not Integer. In BeforeUpdate of My txtPostOffice Field this is my code...

Hi David, Thank you for reply. Well, I tried the code as follows: If (DCount("[PostOffice]", "StampsOrderQ", "[txtPostOffice]= '" & Me.txtPostOffice & "' AND [Date] = #" & Me.txtDate & "#") = 1) Then MsgBox "Remember...only one entry per post office per day." Cancel = True End If And also If...

Hi All... In a form, I have a date field and PostOffice Field. I want the entry to be restricted to one entry daily for every PostOffice. I tried the code as follows: Private Sub txtPostOffice_BeforeUpdate(Cancel As Integer) If Not IsNull(DLookup("[txtdate]", "StampsOrderQ", "[Date]= " &...

Great help Alexandre. I set the criteria in the based query as <>0 since the value in the field is 0 and it works well. Very thankful.

Hi All... I have a form based on Cross Tab Query to show the Orders of a company in the chosen month and year. My Columns are Day: 1,2,3,.....,31. The cross tab query is limited to few fields getting a data from another query with more fields. Every thing works perfect. But, if I have No data...

Very Thankful David.

Hi All... How can I use the function key F1 to F12.. e.g. when press F1 I want to save record, and so on.. Is it possible to do so Many thanks

Saving calculations in tables will load your db which advised to avoid it. Still you can do it by creating a make-table query and update your data to a new table. I fully agree to avoid such headache.

Hi , of course you can. Create a new unbound and choose which character to sort. e.g. =Mid([MedicalRecord];11;3) This will sort the last 3 characters of your Medical record. HTH

True jwindon. This will do the job. Thanks a lot.

Hi All... I have a tabular form, shows names of users with their passwords. If UserName in any record is Admin, I want to disable this record only while other records remain enabled. I tried: If Me.UserName = "Admin" Then Me.UserName.Enable = False Else ..... End If But it disabled all the...

Saleem, Check your mail. Child can accept more than one entry linked to unbound field.

So it's not Child-Master, but UnBound Field. You are true it'll not accept more than one entry.