Search results

Okay, I figured out that I can use the instrrev function to look at data from right to left. I used this function: Right([mydata], InStrRev(1, [Mydata], "-")) in a query in an attempt to get all data right of the "-". When I run my query, I get "error" instead of the data I was expecting...

There are several dashes Sorry, I should have mentioned that there can be several dashes so the data looks like: blah-blah-need blah-needa blah-blah-blah-aneed need to look like: need needa aneed I had tried the expression you suggested already and thought that I was using incorrectly. I...

Hello, I have data that looks like this: blahblah-need blah-aneed blahblahblah-aaneed I would like to have everything right of the dash to get: need aneed aaneed I have used mid and instr to get the left hand stuff. I've tried to modify to get the data to the right of the dash and I am...

Is this even possible? I've been looking for info but have come up empty. If not possible, anyone have experience using ADO and have example code to share? Much appreciated, Al

Two valid options... Both ideas are good. The app is always open, but not on the same machine, so I'll have to do some thinking. I like the second idea too... maybe I could have the scheduler run on the back end server. It's just a windows 2k machine. Thanks for the ideas.

Good day, Here's a functionality I'd really like, but cannot find much in the way info about it... My database is almost always open by someone (7/24 support operation). I'd like to generate and run reports on a nightly and weekly basis without any intervention by end users. Are there...

Splendid!! Now my plans to take over the world are almost complete... Thanks, Al

Good day, Need to use something along the lines of date-1 on a linked ODBC table. Problem is that the date is a numeric format displaying: yyyymmdd. The fact that it is numeric makes it easy for calculations, but not if I want to compare to date() as it is in access. Thanks for any...

Okay it works... Thanks... I had done this before, but the problem was with the structure of the data and subform. Your confirmation made me look elsewhere for the problem. Al

okay...so how many tables Still think you should think about the structure before tackling the original problem.

Might want to rethink the structure... If you think of relationship between sales and customers... 1 customer many sales. Your description seems to be leaning towards 1 customer with 1 sale which changes over time, which I don't think is correct (although anything is possible). Do you have...

I'm trying to move to a new record in a subform... I haven't been able to get it going, so I put a command button on the main form with the following code attached for testing purposes... Me.frmsubfrmSiteanalysis.SetFocus DoCmd.GoToRecord acDataForm, "Me.frmsubfrmSiteanalysis.Form", acNewRec...

Yes it is complicated... Ok, I have a form which displays some records in a multi select listbox. User will select the records they want, click a button and the records are transfered to a subform's subform. The relationship is that one selection from the main form will be one entry in the...

Thanks Wayne, I've been trying something similar, but using ADO not DAO. I seem to be having problems with the criteria string. I'll be trying again tonight with your reasonable suggestion and let you know how it goes. If it works I will be very happy as it's been bugging me all week. Many...

Are the holiday dates stored in a table?

A couple suggestions... -Tie the form to queries instead of the tables directly -Use the "on change" event property of the combo box to change the record source property. A select case might be appropriate. Just a direction to go...if you need more specifics let me know. Al

Try looking up information on Data Access Pages. These will provide the functionality you are looking for. Creating reports is a seperate process, and can be outputted to html if you wish.

Good day, Need some help in structuring a VB function that will loop through records using the specific value of one field in each record as the criteria in a seperate recordset. I have created a SQL statement that gets the records that I need via an ODBC link (for the sake of example, lets...

date(), desktop settings, need something robust Good day, I have an access application with a few command buttons, used by staff to log calls. The default value for the date field is "Date()" For the past 6 months, the app has worked flawlessly. Recently, their machines were upgraded to...

Good day, I recently split my database to be a front end/back end application. I noticed that my relationships didn't seem to be done correctly. If I load the back end, I can see all of the relationships as I set them up, however on the front end, they weren't there. So...I set them up again...