Search results

yes it wasn't a reference error but it seems that runtime versions can't reference to outlook is it true?

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

Can you point me out on how to do this please? Thanks for your time

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

do i type in the criteria section of the query under that field If(thatfield, "yes", "no") as yesno ? that doesn't seem to work any other code I could use?

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?

Thanks thats what I wanted, thanks for your time Cheers

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

So you're saying i should "digitally sign" my project before deploying it? in the wizard?

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?

you're right! Thanks a lot for the tip And thanks for your time

Ok I wont do the restrict thing, but how do I implement individual user logins on the server? All my users are connecting from within a windows domain I dont know much about permissions, audit facility and security

So what you are saying is that I should just add dbseechanges at the end of my statement? I tried this but it doesnt work :( CurrentDb.Execute "UPDATE tblConfirmations SET ConfirmFlag = True Where JOBID =" & Forms!frmSwitchboardF.ListConfirm Forms!frmSwitchboardF.ListConfirm.Requery, dbseechanges

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