Search results

Hello all, I need help. I have create very cool database for Company X. I have found one mistake about validation rule in Field Properties. I have create a few field, which some of them have validation rule Is Not Null, and they must not be empty. After enter information in the fields, they...

Found it...I have just add "819161" value in criteria field for update query....

Maybe, how to update just a specific value in column (my case 819161) with values from another table?

Not exactly. This is just update for entire column. I would like to replace only values "819161" in Shipper_account From Shipment table with values from Account field from Shipment_details table...

Hello all, I need help. I have add attachment Sample.mdb. I need to join two tables, Shipment_details.shipment_number, and shipment.account. But I want to replace JUST value "819161" in Shipment.account with accounts from Shipment_details.account????? I have just start learned SQL. It is...

thanks Boblarson

uf, long code. ok, not long for application. but, long for access :-). can you please mark, what should I have to change? question? I would like to learn VB language, but dont know how to start...do u have a suggestion?

I would like to ask one more thing, pleaseee... It is the same project. I have create macro OutputTo xls format. Export file is caled ExportFile. At the moment, each time when macro is run, it overwrite the file. But I will need a history files for each day. So, how can be done that each time...

I have fill this code with my datas, but all the time getting syntax error. I should change this lines, right? Please correct me, if I`m wrong. Dim stDocName As String Dim stLinkCriteria As String stDocName = "obrThirdParty" stLinkCriteria = "YourID = " & Me.cmbYourCombo //I dont...

I have attached a picture. So when I will select Third Party value, I want to auto open a new form. I think it should AfterUpdate event...

wiklendt 2003 or 2007, and first thanks for help. Question, why which version? I realy dont know how could I set a specific value to open somehting. What do you thing with lookup-s? Can you send attach a little sample?

I didnt understand very well. I still dont know how to set, when user will select specific value in combo box, after will open another form.

Hello, I have a Combo box with 2 values, Shipper and Receiver. How to create a query, macro or code, when I choose specific value, in my case Shipper, I want to open specific form, or something else... thank you to everyone in advance for help

Yeah, that is the best option. Thanks Dcb, and of course other helpers to...

well I`m not an expert, but...I have this field to mark a record with blank or Yes. And I have also a query, which is exporting a records with value Yes to .XLS . So, I would like, after exporting, set back that every record would be blank...

Hey, I have ComboBox with two values, "Blank" and "Yes". If I set some records with value Yes, after that I would like to clear it for all records back to Blank value, default value. Of course would like to be done with Comand Button. I was looking solutions, but... Thanks to anyone in...

I have done, and working... I have done easly with Macro SendObject...

I will try, thanks Maybe later if I will have problems, I will contact again, ok? thanks

Hi everyone, I`m learning access for one month, and more and more like it...but still need help. I have a button which is exporting files into .xls file. I have a button which is opening another application. In my case, that is an Outlook. How can be done, that export file will be auto...

Hey.. I export files from access into xls. I have a macro button to do auto...also have a query for selecting records which of them will be on the export list. So, each time when I export file, like name Sample.xls. And would liek that next time would be export file Sample1.xls, and next time...