Search results

I have a dba from which the VB debugger tells me there is no error i have signed it I'm using access 2k3 i packaged it to deploy it with the runtime version as i always do and when i install it on a machine it shows me my welcome screen i have a log on window on it and then I get Execution of...

I have a simple appointment form which I attached a simplified version pick a customer / a sales rep / a date the form gives an appoint ID (auto numbered) I'd like to add a cmdbutton that will open Outlook and put this appointment data onto its calendar basically create an even with the data on...

Hello, I have a basic Customer/inventory form with basic data on the customer then a subform with the items in storage for that customer, his/her inventory with itemID CustomerID(refcustomer) Itemname and ItemDescription My issue is Customer might check out an item and sometimes restore it a...

Hello I have a basic customer form listing data from tblcustomers with customerID, Customername adresss etc... then I have a subform showing deliveries made for or to that customers My issue is a customer can be a shipper or a consignee (receiver) tbldeliveries has a refshipper linked to...

I hava a field on a tbl set to yes/no on my form it is a check box m dba is linked to a sql server. recently i modified this table by extending the char size of a txt field via sql manager since you cant modify linked table within access. i erased the linked table in my dba, relinked it and...

How do I change the colum head in a list box? I have a list box from a query drawing data from a table one of the item is refJOBID, i'f like that column head to just say JOB ID. how is that possible?

I have 2 "Quotation" forms that look identical, 1 is for export, 1 for import they both draw from the same table called tblquotations now each of them has a subform on which the user select services. The forms open with a code that already displays a set of pre-selected services depending on...

Hi I aware now of the > sign in the format properties of a txt box on my report so it will print data on my form in all caps. What I am looking for is for a code to put on my form that when I click save it converts my typed data into all caps onto the database. is it possible? I'm looking for a...

I have a quotation form where the user select a customer from a dropdown combo box. Next to that cbo box is 2 buttons: a lookup button to open the customer form to the selected customer data and a "new" button that opens the customer form to a new record to add a new customer. Here is my...

I can't get one of my form to open with a specific value in one of its combo box. i tried to set the default value but nothing works this is the code of the button that opens the form. it is set to return a set of services in the form's subform the combo box is called: cboRefTypeSales and the...

I'm deploying a runtime version of my DBA but when I open it always gets a security warning "this file may not be safe if it contains code that was intended to harm your computer. Do you want to open this file or cancel operation?" How can I resolve this?

I'm using this code on a cmd button to confirm an order and at the same time take the order off my listbox which lists pending orders. CurrentDb.Execute "UPDATE tblConfirmations SET ConfirmFlag = True Where JOBID =" & Forms!frmSwitchboardF.ListConfirm Forms!frmSwitchboardF.ListConfirm.Requery...

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...

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...