Search results

YA CREATE A FORM NAMED "SearchBox" or anyname Then Create textboxes for feeding parameters to Report Rename them as per your choice and then in Query , where you've placed filter criteria Type as said by Brianwarnock ! Thanks for reading

You should create a Blank Record in Customer table which data is supplied to "Rooms" table and "bookings" table The Blank record shud be : Example : Customer name : Vacant Customer Age : 0 Customer ID: no Customer Address : no .... Now in the Join query stated above, you should also set a...

oh sorry to forget !

I think fault is in your table making system. Not Fully (There are many ways of doing a thing) May be this way out Tables : Rooms Table : Room No. Room Location RoomType Facilities Booked to ex-data 212 firstfloor Executive All Mr. Andy(combobox lookup from...

OK SEE ENCLOSED please solve....

My simple question again Asking... Last forum thread did not resulted in any repl. Please reply to my Problem if you're being so eXpert : I've report. a embedded Excel OBJ OLEunbound55 - named It's Excel file already made in windows It's Linked But when displaying data inside excel file it...

Re: code to print multiple copies : for invoicing custom labels Dear sir, I want to set a code to print three copy of a Report INVOICE_F but in different way I want to message viewers "Printing three copies" this is not big thing But the big thing is I want a Text on rightmost side...

YES THEY HAVE invoice_no field in common . As any Material issued needs to be put up a invoice serial no. so they have invoice_no field in common

note, understand clearly dear mafhobb : table relationships in backend must be updated to frontend version in each pc second thing in frontend IF you missed to create any relations between tables/queries in B.E then it can be created in frontend which does save on frontend So if there are 5 PCs...

shud challan_DLR form shud be based on Query whos fields taken from Invoice_SL filtered by UID value of Invoice_SL

YA THE BEST WAY IS to call the Textbox value depending on which u want to auto-fill the valued then process it with nested IF and then finally u wud see the result I Suggest just write for one/two table field only, if success then write complete If Else Script u can AWF search for...

ya, best thing to learn is Discover ! how much u Dig into Internet resources, how much u find !

Dear sir pr2-eugin, Pls see my posts related to VBA in Newposts section Pls thanks in advance pls. solve Sirs's pleeeease solve it ! Many thanks ia

a hi ! all there i just created two forms which r so inter-rel. with each other 1. FormName : Invoice_SL Form controls which need to be copied to another form : a> PO No b> PO Date c>Dispatch Details d> - is a filtered list depending upon UID of Invoice_SL Form 2. formName : Challan_DLR...

Look for File-->External Data--->Import or the link Rx buddy has given Access and excel are both friends ! there r many ways of communicating data between them ! Microsoft has designed and filled Heavy capabilities and endless possibilities into them with small amount of Harddisk usage !

i don't want to send a records bunch but just a UB field value

Private Sub ReportFooter_Format(Cancel As Integer, FormatCount As Integer) Dim xlApp As New Excel.Application Dim xlWrkBk As Excel.Workbook Dim xlSht As Excel.Worksheet ''Dim myRec As DAO.Recordset 'Dim fldCustName As String Set xlWrkBk = GetObject("yeru.xls") Set xlSht =...

sending....

I've vba in Report onformat the vba code does some data copying to External Excel file (premade by vba) Now on first run, i got success But on opening the excel file, it showed blank space + Error"File already opened" No White Spreadsheet is shown with data to seeinto file, i created...

BE TABLE RELATIONSHIPS ARE ONLY FOR TABLE TO TABLE BUT FE TABLE RELATIONSHIPS ARE FE TO FE QUERIES/TABLE/QUERIES and if there's something reg. update to Frontend from backend then goto Tools-Database Utilities-Linked Table Manager Click Select all Click Ok Now all tables and relationships...