Search results

Hello guys , Do you know how can I set passwords with different privileges in an Access 2007 ? Thank you.

I tried to import the Excel file into a new table and the checkbox is enabled. Is still disabled when I try to import the Excel file into an existing table. Any ideas ? I have an application completed and running without any errors and I cannot import my data.:confused: Any help would be...

Hello everybody, My question is related with Access 2007 and the import process of an excel file. During the import wizard appears a check box "First Row Contains Column Headings" which I know exactly what it is. The point is that is disabled and always checked. Do you know why is happening...

I took in serious consideration your advices. It is more clear how I have to design the project now. Thank you for the reply. :D

Hello everybody, I would like to ask you something that until now I haven’t found any answer. Official Microsoft says that it can’t be done. But honestly I must find a solution asap. As my boss said. :mad: I have an exported excel sheet from the SAP system. Then I have to import this...

Hello guys, I import an XML file in my database and I produce a report. One of the fields that I use has Date Time Format (27/04/2010 11:09). My boss asked me to change this string: 27/04/2010 11:09 to 201004271109. Without special characters and the date time from dd/mm/yyyy hh:mm...

Every department has more than one printer. I tried to print from notepad and I can see all the printers of the Accounting Department are ok. And I succeed to print. The point is that every time that the user clicks the Print button, we receive the print out in my Deprtment (IT). And...

Hello everybody, Recently I finished an application on Access 97. Everything works fine, except the print button. I have on my Form two buttons. Print & Preview where you can print directly or preview a specific report. In my company almost 30 people use this application. Two of them, they...

It worked ! Thanks a lot !!!

Thanks for your reply but the link is not active.

Hello everybody, I use Access 2007. I created one Split Form and through a "Preview" Button I want to open a report with only the current record. My problem is that on the report I see all the records. Any ideas ? This is for my job and it is quite urgent. Any help it would be highly...

Good morning to everybody, I am working with Access 97. Do you know how can I open an Internet address through a button ? A hyperlink. Thank you in advance.

I meant that the form calculates a new tax. For vehicles. Some of these calculations didn't work properly. BUT while I was trying some other methods yesterday. Finally I tried again the double quotes and it worked !!!!! I can't explain it. Thank you for your reply. :)

I did it already and I don't receive the error message ! BUT the rest of the application doesn't work :D

Dear friends, I have a Run Time error 13 in the following scenario: In my form I have a combo Box (Select_Version). In my VBA Code I have this: If Select_Version = 3 Or Select_Version = 6 Or Select_Version = 9 Then FP = 0 End If This means that if the combo has 3, 6 or 9 values...

Hello my friends, I have a quite unusual issue to solve (At least for me it is unusual :confused:). I have a Form and inside of it a SubForm. The Subform has a button ! Which adds data to a Table A. Simple ! In my Form I have a TextBox also which takes data From a Query (This particular...

I found it guys ! I added an extra field in my table: Constant with default value: 1 and then in my form i did this : Private Sub Form_Load() Dim con As Integer, varX As Variant con = 1 varX = DLookup("[Baumuster]", "XML_Vehicle", "[Constant] = " & con) Baumuster.Value = varX...

If you have any proposition with VBA I am all ears :) I want to do it with text boxes because I have a range o fields with Vehicle Prices that I want to calculate. Example: Vehicle A: Net Price: 100 $ Vat: 19 $ Total: 119 $ --------------- Then the customer want some extras: Extra A (Net...

The DLookup it doesn't work. I don't know why... I tried Combo and List Boxes and it works fine. But is not suitable. Because later on I want to do some calculations. Discounts etc... And this is my actual problem, the calculations. I really need your help guys.

I use Access 97 (unfortunately...) In the properties window, in the Tab "Data" I can see only Record Source. I wrote : =[XML_Vehicle]![Baumuster] XML_Vehicle: Table Baumuster: Field. Is the form bound to the table? i.e. Does the Form have the Table as it's Record Source? According your...