Search results

bump- any ideas?

Okay, yeah, I figured I would have to go with a textbox as Dhamdard had mentioned, I suppose its the same either way, was just wondering if it could be done within the button's onclick event rather than in the query itself Thanks!

Haha, everything gets checked before the data is actually used. This will just take the busy work (Manual matching :eek:) out of the equation.

I know it seems like this would be bad practice to automate. BUT, in the year I have been doing it in this fashion I have only run into like amounts on very few occasions and they are always of very small denominations ($50 - $100) - which would be very easy to reconcile. Otherwise there is...

It's not the specific deposits I'm looking to match... it's just the like values. So in your example, list one value one would match up with list 2 values 1 and 2, list one value 2 would match up with list 2 values 3 and 4, and so on.... The reason this has to be done is because there will be...

Hi all Is there some kind of matching procedure that could be created to find matches in 2 tables. The catch is I'm not just looking for like values. For example: List 1 has 30 records (Shows all of the deposits that were made to the bank in a given month -usually 1 per day) List 2 has 100...

Hi all - I'm looking to pass a parameter (a Dlookup function) to my query during the "OutputTo" command (or really anytime I want to call the query, but for now this is what I'm doing) My query is to be filtered base on a date however, I'm not sure how I can set the value of the parameter...

While we are on the subject of using multiple subforms on forms, is there a "best practice" as far as how many to use and how they are used as far as overall functionality is concerned? I mean, it seems like for any basic "Employee Info" database, one would have many subforms all related to an...

In response to: Setting the "required" property on the table itself should prevent users from partially entering records. You can also be very specific with what you allow users to enter by either using the data validation on the tables themselves OR what I tend to do is on the "SUBMIT"...

have you tried using a list with a rowsource of the data you want to display? then, perhaps use me.LISTNAME.refresh after your .addnew/.update code

Hi Bob - I, too, used lookup fields to build all of the relationships in my db... Is there a VBA I can use to cycle through every field of every table to remove these? After reading what you posted with that link above I noticed that I was having some of the problems that were mentioned, but...

At the moment there are 8 separate contracts, all a bit different- only one of which as an anniversary date override...

conversely I suppose you could use: chr(Number + 64) to return the Letter

This would have to be a temporary table (deleted after each time I use it) because I need to make this application flexible enough to allow for exceptions. Like, if someone changes position titles and moves into a completely different set of contract rules that start them at a different step or...

That's the part I'm looking for help with - I'm trying to run this function for each day of the year. which will tell me where in a salary range an employee falls. it will either return a value from 0-10 or "N/A" for employees who don't move on a step scale. @spikepl You're correct, the value...

What I'm looking to do is have "asofdate" = 01/01/CY then 01/02/CY then 01/03/CY and so on... til 12/31/CY I started with something like: dtStrtYear = DateSerial(Year(date), 1,1) dtEndYear = DateSerial(Year(date) + 1 ,1,1) dtDayDiff = dtEndYear - dtStrtYear then perhaps Redim arrSteps(1 to...

OK - It may not be so much that I'm struggling but moreso that I'm just completely lost. I have a function that finds a value based on a date "asofdate" what I'm looking to do is find the value that the function would return for each of the days of the year. Then once I have all 365/366...

You're right, a lot of the functions can be done in queries, the reason I made functions was because I was misinformed that queries actually slow down the db more than what I'm doing now and was shown applications that had no queries created at all... I have clearly not been using queries to...

So, instead of using SQL to get my data from tables, I should create a query, than open the recordset in VBA and retrieve the field I am looking for (based on a parameter)? I tried using this code to create my parameters (such as employee ID or date effective): Dim arrParameter(4)...

Thanks for your responses: The problem I see with this is that it seems I can only link a report to one query and it wouldnt be possible for me to have one query with all of the functions I need (obviously unless I called a function from the query, which I think would defeat the purpose?) -...