Search results

You have selection boxes? Use that! If you are selecting a date range for the query, then use the dates that were entered into those boxes. Format the dates the way you want, such as "mmmm yyyy".

Hi talktime, You will need to determine what the earliest and latest dates are in your results. How is your VBA? Are you familiar with Domain functions? Regards, Marvin M

Inkognito, I know it's been years, but your last post on this thread said your booking system was working pretty well. It was interesting reading the story and seeing it progress. How's it going now? I like your identification of the error code for the record having been changed by another...

"I deploy the front ends by means of a log-in script which checks the version and downloads the updated version and associated files if necessary to a folder on C:." Steve, You mentioned this in an old post. How do you download the updated version? I've tried to do this and hit a problem...

Hi Faisal, Is this an Access issue or a Java issue? If you want Java experts, try here: http://java.ittoolbox.com/ If you are talking about an Access issue and you merely access the Access form with Java, maybe it would be better to leave the Java out of the question. It sounds like your...

Mohsin, I have to agree with almost everyone else that monkeying around with the field is a bad idea. However, I must say that what you are asking is possible to accomplish by one means or another. Please note that the others have given invaluable advice. The most poignant is about not...

Hey All, I think I just figured out where I got the original idea for my code and I want to give a tip of the hat to Allen Browne. His code for locking controls, found here, http://allenbrowne.com/ser-56.html , put me on the right path for developing my function for reseting controls. Thanks...

Rosemary, If you are still looking for an answer, look here: http://allenbrowne.com/ser-56.html _________________ Regards, Marvin M :cool: Windows 7 Professional, MS Access 2007/2010 Windows 8 Professional, MS Access 2013...

SynSoc, I see what you are trying to do here and I see that the question posed in the subject line has been resolved. However, I want to share my code with you for clearing the controls that doesn't require you to remember to add new lines when you add a new control to your form. I copy and...

Martin, I use A2007 and couldn't get it to open. So let me take a stab in the dark and maybe it will help you in your investigation. Just because your table is arranged this way--CustID, FirstName,LastName,Adress1,Newspaper1,Newspaper2--doesn't mean that the query is too. Unless you did...

jwf, I saw an idea like this in another forum. The idea was to set the default values with a button. Say you have several/many records to input and in this batch, all the City, State, and Zips are "San Francisco", "CA", and "94132". His idea was to enter the first record and then click on a...

Hi EU, First things first... Let's get the names of your fields straightened out. I see 'student', 'studnet' and 'studnt'. Now, these are all valid names, but they are confusing. Before investigating any further, I would go through and double check your field names and control names, just to...

Myrtle, Yes, you are right about the values. I prefer to use the constants True and False so that there is no question. True = -1 False = 0 However, there is a little gotcha to watch out for. Anyone using checkboxes should be made aware of this. There's a Property called Triple State which...

Yeah, but the more I thought about it, the more I thought, "That's really not a bad idea." I know, from working with data entry, that sometimes you repeat the same data in the same fields over and over again. You get tired of typing "Los Angeles" a hundred times without a typo. There's the copy...

BigAlpha, Two answers: 1) Almost. 2) Yes. Instead of changing the Default Value, I'd prefer to go with the Value property. And what is the value you want to populate the field with? Certainly it's not going to be Chr(34) & Me.Control1 & Chr(34), is it? That would take the value of Control1...

Oh, I see what you mean. Paul is right. I always put a semicolon at the end of that SQL statement. Does it work without it?

sohailcdc, You've got it already! Just take your sql1 string and put it into the Row Source property of your ListBox: SELECT Currency.[Currencycode] AS Code, Currency.[Currencyname] AS Name FROM [Currency]; _________________ Regards, Marvin M :cool: Windows 7 Professional, MS Access...

Alan, You said in your original post that this field [txtNo] is a text field. Right? You may need to convert your text to a number, add 1, then convert the result back to a string to use it in your table. I'm not sure if the automatic conversions work all the way through this function or not...

Michal, I know how it is. I had a similar problem. Instead of having the form creating an automatic new record (with bound forms), I had an unbound form. In which case, no record is created until the user hits the Save button. In this situation, a user may think that they've entered all the...

Robbie is right, but I don't like making those calculations every time I want to change the time. I will set the Timer Interval to 1000 almost every time (60000 on certain projects). Then in the code, I use a constant to specify the number of minutes. A conversion factor of 60 is built into the...