Search results

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

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

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

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

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.

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

Hello everybody , I have one table with 3 fields. The table also has only one row. I want to display to an Edit Box in a form the second field and I get the error: Name?. Do you know what does it means? Example: Field A, Field B, Field C Row A 100 200 300 I want to...

Hello Guys, I am using Access 97. Do you know If I can use the function RIGHT in the SQL syntax. And If, how ? Thank you in advance. :)

Hello everybody, I work for a big Car Manufacturing Company from Germany. Μy manager assigned me a kind of "Mission Impossible" project. It is critical for me to accompish this task my the end of the week. I would be greatful if you can give me some help or some guidelines. I have an Access...

Hi guys, I have a Button and a radio button. The scenario is very simple. Everytime I click the Button (Apply), my code should check If the Radio button = True Then Execute a Query. So I wrote this : Dim strSQL As String Dim Arial_f As OptionButton If Arial_f.Enabled = True Then strSQL...

Hello everybody, Lately I started dealing with dynamic reports. I am searching over the internet a "How to" article according the creation of this kind of reports but I didn't found something yet. Guys do you have something to propose for reading ? Here is what I am looking for...

Hi guys, I have a variable TDate which is Date Dim Tdate as Date Then I use the function Date to get the current Date. TDate = Date(). Actually I want only to convert the year to integer and store this number to a new variable. I don't have a clue. Any ideas ? Thanks !!!

Hello guys, I have a listbox with 6 columns. Tha last 3 columns are Hours, Minutes & Seconds. I have three other edit boxes (Total Hours, Total Minutes & Total Seconds.) where I want to summarize the column data. Do you know how ? :D

Hi Guys, I am in a quite difficult situation. My boss asked me to export 3 tables from an Access 97 DB to text. Dilimited. This is not my actual problem. I know how. My problem is that I have to add a Header( With the NOW() Date) and a Footer with the result of a Row Count for each Table. As...

Hello People !!! Recently I started working (For the very first time) with Listboxes on Access 2007. I managed to link my listbox with my Table and I also wrote some VBA in order to create a button ADD Data. BUT now I have a new challenge to face. :rolleyes: Do you know guys HOW can I create...

Hello everybody, It might look simple ans silly. BUT I really have this problem. I created a ListBox on my Form where it takes a parameter from an Edit Box and brings me back data from a table. IT WORKS BUT ... I can't refresh the list box when I press NEXT or PREVIOUS. On these buttons I...

Hello Boys, I was wondering if you have any useful articles or samples to propose according List Boxes. I want to add values to a listbox from an edit box through a button ADD. (Actually this is a List of CD Tracks. I want to save this list in a database field. Is this possible ?) But I...