Search results

I'm making a version of my dba using the upsizing wizard, then i'm packinging it to distribute it as a runtime version and save the data on sql server But i'd like to be able to keep track of who is adding what to the database. How can I check who added what data? from which station? how can I...

I'd like to have a form that works like a calendar but build like a listbox. In which my scheduled orders are displayed by date on a calendar format, and where the user can click within a day to select an order, just like in a listbox. is it possible?

I'm sending report off a quotations form. the problem I have is that it attachs the report called rptQuote to the email but doesnt have any way to differentiate it with other quotes sent to the client. In other words I can send quotes everyday to the same client and they will all be called...

I'm trying to open a form with a value in the a combo box. From my switchboard, I'm opening a form called frmQuotations record source tblquotations. this form has a combox box called cborefsaletype with control source refsalestype. the combo box has bound column = 1 and runs a query SELECT...

I have a "Shipping Deadline" txt field on a form called frmQuotations. the record source of the form is tblQuotations the control source of the txt box is ShipDeadline which is a date field on tblQuotations Right now the user types the date in. But by mistake someone could enter 05/30/2006...

I have a form called frmQuotations (datasource = tblQuotations) which opens with a cmd button on my switchboard. On this form I have a combo box called cboRefSalesType which refers to tblSalesPackage tblSalesPackage which has 2 fields: SalesID and SalesType (ex: SalesID 31 = SalesType Export)...

I need to install the database i created on multiple computers that dont all have access installed. I can't find Access Developer extensions. I have Visual Studio Team Edition which is supposed to include Tools for Office i do not know how to go about deploying my database with it Do you know...

Thanks for your reply My thing is that from the switchboard, the user will ultimately select the type of quotations he'd like to make Quotation A will open a form which is from the Table tblQuotation but in is subform a selected list of services is pre selected, so the user just put quantity and...

yes I was told by the administrator Sorry about that, I wasnt sure where to post the issue. Do you have any idea on the matter? Thanks

Here is my sample DBA I'd like to solve this issue when I open my Quotations form I'd like a set of services to be selected by default, ex: Brush and Pen. So the user only has to input the quote amount is there anyway to have the form open with a script like: "on open (or on load). in subform...

Here is my sample DBA I'd like to solve this issue when I open my Quotations form I'd like a set of services to be selected by default, ex: Brush and Pen. So the user only has to input the quote amount is there anyway to have the form open with a script like: "on open (or on load). in subform...

Found a bunch of stuff not sure what is good Any pointers? Thanks a lot for your time btw

How the hell do I do that? ;) Can it stay on access? Is there anything on the onload fonction that can say something like "in subform select refproduct where product from tblproducts = 1" ?

Thank you so much for your help and the tip I changed my combo box names. If you could just give me on line exemple on how to have default set values in my subform on load it would be fantastic Thank you so much

Here is my DBA I'd like to solve these 2 issues 1) when I open my Quotations form I'd like a set of services to be selected by default, ex: Paint and Pencil. So the user only has to input the quote amount 2) when I click on the "new" button in the confirmation form, I enter a new customer it...

I meant 2 instances of Customername

Ok so I put instance of Customername in the query from the same table. How does the query knows to display the customername form the first combox?

Hi, I see what this does but it doesnt solve my problem In the sense that once I have 2 different tables I will have to enter new data in both tables. Unless there is a way to auto copy the data to the other table. All My customers can be SHippers today and receiver (consignee) tomorrow. I can...

No it's a text field in TProdQuote How do I go about coding my main form to return the desired refproducts in the subform? Thanks

OK I have form FOrders from table Torders has orderID, refshipper. refconsignee, etc... i have made combo boxes for the field refshipper and refconsignee both refer to my table tcustomers. My orders are made on a 3rd party basis A shipper today can be a consignee tomorrow Therefore I'd like to...