Search results

Hi Paul, thanks for the tip. I will check for the specific points you mentioned. I do try however to edit the record directly from the table without any forms or query open. It still come up with the same error. This is where it got me, when I tried to enter details directly to the table, it...

Hi All My department has customer database using microsoft access with the main table being a linked table to SQL-Server database down in IT department. I've only been recently made aware that the staffs have been having problem when trying to change or delete old data. It keeps on bringing up...

Sorry for the confusion, this week report is always about previous weeks data. Hence, the input would be the last week ending date. For example, if I do the report today, the data would be for Week ending 4 March, 25Feb and 18 Feb. Such like: WkEnding 04Mar07|WkEnding 25Feb07 |WkEnding 18Feb07...

What exactly are you trying to achieve? I might create an open report button, and pass on a string to that text box on click event.

Hello, I have a table in my database which display supply and return of product from mon-fri. Field names are: Date, Mon(Sup),Mon(Ret),Tue(Sup),Tue(Ret),Wed(Sup),Wed(Ret), Thu(Sup),Thu(Ret),Fri(Sup),Fri(Ret) The date is always a sunday's date which indicate the week ending where the sales...

If you have access 2007 (which I don't), you would have the ability to generate report into PDF. However, previous version of access would require an external library which you need to purchase. Please be carefull in choosing to buy products, as what you need is a library to be used in your...

Thanks for the help guys. My program works beautifully now. Apparently I was looking for the wrong thing in my report before, hence I thought it doesn't work. Thanks for all the help.

Thanks for the replies guys. I have noticed from other threads that it is possible to do this in on open event. However, I don't seem to be able to get it working. Is there more to it than just write eg: Private Sub Report_Open(Cancel As Integer) Me.RecordSource = "SalesTable" End Sub I...

Hi I'm trying to create a report that would display data from different tables with similar structure. I have some 30 different tables which outline 5 different products for different years. It is impossible to put all of them in one big table since each of them are used by different...

Hi all This gonna be a long one.... I've search the whole forum for answer to this problem, but couldn't find the one suitable enough. I have a quote table with the following field: QuoteName QuoteDescription QuotePrice and booking Table: BookingName BookingDescription BookingPrice The...

Hi, all I have written some codes to insert data into a table. I'm trying to get rid of the pop up message which say: Can anyone tell me how to do this? Cheers

Thanks guys. That works wonderfully. Cheers arnodys

Hi all, I have a main form which contains buttons to control all other window. I'd like to prevent user to work on two forms at the same time. Can anyone advise me how to disable the main window while the second window is opened? thanks

I need to export a specific record in the table. The menu's export option only export the entire table. Is there a way to define certain record to export? Thanks

Yes. But I called it "BOOKING" table, because this database is built for a travel agency. Hence the main table is "BOOKING" which uses "BOOKINGID" as primary key, which then I use as foreign key in the other 2 tables (PAYMENT, and COST).

Try to invoke value properties of the method:

My apology... I haven't been very clear in my explanation. I forgot to mentioned that I do have a common "ID" field which relate the two tables. When payment records exist in payment table, my query are ABLE to return the desired calculation. But my problem start when there is no payment has...

That's normally what I did in the rest of my tables and queries. But in this case would be difficult, since it is impossible to have any record in the payment table if the customer hasn't pay. I need to be able to show the user how much the customer need to pay, including if they haven't pay at...

Hi all, I have a problem in returning values from 2 different tables because they are not related. Let me explain: I'm trying to do "Payment Due" query by substracting the amount in the "Cost" table with the amount in the "Payment" table ([CostAmount]-[PaymentAmount]). However, since no payment...

Hi all, Please note the following table: ShopID | Desc | NumberItem | Price each | Total | ShopGrandTotal 01 | Drills | 2 | $200 | $400 | $425 01 | Nails | 5 | $5 | $25 | $425 02 | Hammer |...