Search results

Perfect! You are a life saver!

@NickHa - Sorry didn't get back to you sooner, had to go on a short business trip. I tried the code, but I'm getting an error, which I believe may be from either the way I have the dates when calling the function, or how the text box is meant to display the number: 1) I created a dummy...

I have a form with a New Record button, a Save Record button, and a field with a date picker. I also have a simple VBA code that saves the last fields' values as a default on the Mouse Up event of Save Record. If I choose any date other than the current day, I can click Save Record and...

It's a great suggestion, but doesn't seem to work quite right. I locked the other date picker field and took away the calendar (it's pretty much just for display now). I changed the "Limit to List" to No on the combobox. I can write in any date I want for the combobox, but it doesn't allow me...

The date picker is so that they can choose a new date from anytime. The combobox is so that they can see what dates have been used and change the values in those dates if necessary. Will your suggestion still only have the combobox list all the dates used? Or will it have all dates?

I have a combobox that checks for saved dates and allows someone to choose from the drop-down if they want to go back and change values in the fields from that date. I have a date field with a date picker to choose a date that has yet to be saved. My issue is that if a person uses the date...

I am creating an Access database that will be created from several Excel workbooks. The final results will need to be in both an Access report, and an Excel worksheet. The database will be online, likely through a remote desktop solution. I can think of 2 methods in which this could work: 1) I...

Alright, decided I could get this and I have your solution: Go into your macro and move CloseWindow above OpenForm. Not sure why this works, but it does. It also works if done this way in VBA. Be wary though, this can cause trouble if you have other pertinent commands that need time to be...

I did a bit of testing and it has to do with your switchboard form. I first tried a couple of different ways I could think of using SetFocus without succeeding. I then tried changing a few properties, again no help. I even tried deleting the macro and using simple VBA so I could use Me.Visible...

I have a form that is basically general information. The information changes maybe once every two or three weeks. I have a date field with a date picker to choose a past or future date. I have a combobox with all the definitive dates that already have data. And I have a Search button so that a...

Not sure if this helps, but why not set the tab order so that the field you want is always first instead of using SetFocus?

I think I may have figured it out. Without any data in one of the tables, the entire query will show no data. However, if it at least has some data (even if not for the field chosen), then it will work as expected. Why is that?

I have four tables all related by date. I want to create a simple query that asks for a start date and end date in order to populate a report as such. Every time I create a query with the Wizard and include more than one table (or even more than just the "Days" field), my parameter Between...

Thanks for the reply. There are multiple fields where on one day a value may be present, and on others, there may not. I'll try to give a better example of what is meant to happen: a) We have three columns (fields) of data (values). There is Date, Black iPod, and White iPod. b) Date always...

I have a bunch of fields with values organized by date. The dates to be displayed in a report are chosen by a Start Date and End Date parameter in a query. For the most part, subtracting the two dates and adding one (which I still need to test) will be the dividing number for the total for an...

Thank you. I will look into that as they had suggested using random autonumbers which is why I put up this post.

Well, it's actually EQLData. Beyond that, if someone wants to be condescending to me I have no problem pointing it out. If you don't realize that you are doing so then it is a matter of comprehending what you type does not convey the emotion you may be trying to express to me. The real...

I have someone testing the EQLData.com plugin, if it doesn't work I'm going to have to be forced to convert to MySQL or something of that sort and see what can be done about an extremely easy GUI, a front-end, synchronization, and user-level permission (I think the easiest part of those items)...

Again, if they had time to find someone I'm sure they wouldn't have asked me to try. Unfortunately it rests upon me, and I don't intend on failing.

Thanks for the condescending words Rain, but they don't have time at the moment to search for that. I volunteered unaware they wanted an online database instead of a LAN. Nothing that has been said here has added to my knowledge of Access as I only ask questions after doing a lot of research. I...