Search results

Hi guys I was wodering if somebody can give me a link to a post where its used the object in access ( with property let/property get stuff) and some link where multmedia is used. I need both for a project for my final exam and I didn't find by searching. Actualy, what it would be good is a...

Hi guys I am using Access XP and I am trying to make a MDE of a db, but when I try the part for MDE in tools is grey, so unusable. I convert the database to 2000 format, the MDE option is not gray anymore, it even (looks like) work, but when I open the result is a .mdb not an .mde. So not...

Hi there Once, Mile gave a very useful function, Timeconversion, that I paste in this message. I have a question about it: is it possible to prevent somehow that if I pass a null value as argument the function returns a null value, not an error? Here is the function: Public Function...

hello People Nice new house here huh question: I have a query that show data from two tables and uses a third table for a condition. It's a left join so that shows the results even though in the second table I don't have records. Now, when after 'WHERE' I add a condition like: and X NOT...

Hi people I try to change the color of a data field on a form depending on weekday, so it would be friendlier and easier to manage. I am talking about a form with like 10-20 records. Now, its working but instead of changinf just the field that I want it changes all. I wrote this test code...

I post it here not to be acused that I didn't try I read everything on this forum about blank ages, I still got them. The blank pages from ime tot time. The total in the footer is not working neither. I post here the sample hoping that somebody would take a look. Thanks in advance PS U...

I found a free version of runtime Access on a dutch site, named Art (the runtime). I tested it and it works a threat. Do you guys have any idea, is that stuff legal? It isn't Microsoft written on it or something. email me if you want the link hair76@yahoo.com

happy new year guys Question: I have a report based on a query that has like 300 pages and I have to print it client by client. But it prints continous, mixing the clients. Surfing the forum I have seen something like - go to detail, right click, and force new page or something for splitting...

I have no choice, as I didn't find the answer searching the forum. I need to transform a time like 32:30 (actually is a string) in a usable format, like 1,76etcetc so I can put it in calculations. I've tried cdate function and a lot of stuff but didn't work. Should I transform everything in...

Hi I had a big procedure and I wanted to split it out in smaller parts. But - bad luck - I saw that if I declare the recordsets in the first sub and after I try to use them(like rc.movefirst etc) in a called sub, it ain't work. like this: Sub example() Dim db as dao.database Dim rc as...

Here is the question I have an access 2002 db and I want to make it an ADP project. I install everything I need, I import the tables and the forms, copy the queries and rebuild the relationships. Is it going to work? If so easy it would be wonderful. Dan

I needed the first and the last day of the week. I wrote this: Private Sub Commande10_Click() Select Case semaineencours Case Weekday(Now) = 0 Me.datedebut = Now - 6 Me.datefin = Now Case Weekday(Now) = 1 Me.datedebut = Now Me.datefin = Now + 6 Case Weekday(Now) = 2...

Why do I have problems with manipulating a dao recordset on a form based on a query? Its always giving me the same error, "too few parameters", but working just fine when it's a subform or a table. ANy tip is welcome, thanks in advance.

Hi there Did someone connected a Access database to a windows Mysql db through ODBC? I am talking about the windows version of mysql and windows version of ODBC drivers for windows Thank you

There is this function : Function TimeConversion(ByVal tempTime As Date) As String 'On Error GoTo Err_Error ' This routine is given values from the calling procedure and calculates the time ' beyond the obstacle of a 24-hour clock Dim lngDays As Long, lngHours As...

Hello I attach here my little base to be clear. On the form named Clientcontrat I have the code of the client, the starting and ending date of the contract, and the days + number of agents that has to be covered. I want to pick up those and (by pressing the button 'planning)populate...

Hi I have a form called x On this form a text field named Text1 I want to pressa button so that what was written in the Text1 field to go in a table I did something like this: Private Sub Commande72_Click() Dim db As DAO.Database Dim rc As DAO.Recordset Dim q As QueryDef Dim a As String Set...

How do I reference the result of a query in code? Is it something like Querys!Blabla? What is the exact syntax? Thank you

I have two tables with a relation one to many - so in the first one a primary key and in the second a foreign key. I make a form with a subform using the wizard, based on those two tables . I replace the text box on the form with a combo, and I set the source of the combo with a query from the...

So, again I'm stocked with hours/ in my table I have a starthour and a finishhour. And in the form there is a calculated textbox that makes the difference = finishhour-starthour. Now, when the finishhour is midnight, no matter if I write it 00:00 or 24:00, the returned value from the...