Search results

If I am understanding you correctly:: I could add a new field - we will call it "5-Day" as a Y/N field. With an update query, instead of my query that has 5 or 6 subqueries in it, I could filter off of this. GENIOUS! :D I will have to work on that... My attempts however at pulling out the...

I am tracking extreme useage on account numbers. I've set up a table to add the information on a daily basis, but I'm looking for suggestions on if I have things set up the best way possible... Currently the table has the following Fields: Report_Date / Account / Usage / Sent / Received /...

Okay ... So I am officially calling myself out as an idiot. (again) I went back to another database and checked out an update query I wrote recently that would do about the same thing as this one... Update a yes/no field. The difference is that query updated everything, not a select # as this...

hope this works. The query "Extreme Use Data - Update Sent" is currently set up as a select query. I'm trying to write this query as an update query to update the sent column. The other query (not here) will basically be identical; except for using "IS NOT NULL" for the joined fields and...

No, no errors at all when running either query. If I run this as a select query, all data shows as expected. If I run it as an update, all that shows is the yes/no field but it is always unchecked. Same thing goes if I try to run it but update a notes field. I get the correct number of...

JZW; It worked.. I'm still trying to get my brain wrapped around it all, but essentially it worked like a charm. Thank You. What is even better, is if I change the "IS NULL" to "IS NOT NULL" I can get the opposite recordset. So I figured my next step in this process would be easy. I need...

First off - thank you for the replies. Work has gotten away from me and I have not had a chance to get back to this project. And, I absolutely REFUSE to work on this in the evening from home. Last time I did that and tried to claim it on my time card I was severely chastised. Pog - Sorry I...

I have a table of overdue notices that is updated daily and a report is run based on today's entries into that table. Everything works fantastic, but I want to make this process better - and eliminate a little work for both myself and my customers. Basically, the entries are all automatic from...

Thanks Bob! I'll give this a try and let you know how it works.. :D

I have a query that needs to only return part of the data stored in one field. The data that the query pulls is formatted like this: 3652 #18 What I need to use is just the "18" out of this result. Yes, I know that it would have been better to design the table using two fields for this...

There may be other forums out there that are more specialized than here, but I love this site... Is there a way to add restrictions to a network computer such that the particular computer can function over the local network but not access the outside internet? Or, limit the internet down to a...

Toledo I've got a customized PO database I use here at work. I could look into stripping data from it and passing it along, but not sure how much that would help. It's tied into other DBs (like Inventory and Production) and without those DBs as well - at least for me - using a stripped down...

jdraw; Thanks.. The way you are describing things is just how I have it set up now. I have to log in daily/whatever to check for new requests. While this works (I've got reports/etc that run when I log in) the problem I run into is I seem to be away from my desk more and more lately. I...

jdraw Wish I was good with writing VB like that! Would make my life a ton easier! Thx for the info; I may use this in the near future, but for the time being the RunApp command is working for me. :D Now If I could just figure out a way to send myself a msg from Access......

Nevermind... I was using the "RunApp" command and pointing it to the MDB file. I found a reference that said to RunApp won't open a file, but opens the EXE program. With that bit of info I was able to get everthing to work as I was hoping. :D

So many thanks!!! Worth every 30,000 you should have! Congrats JP

I would have thought this was easy, but my tries have not been successful. I want to be able to open a database with a button. I know that I could link tables/forms/etc between the two, but for security reasons I would rather have a button to open the seperate database. I've tried searching...

I've got a database that allows all users to review an address register. If they find errors or mostly get updated information they have another form they can fill out to make the recommended changes. Only I have access to the main DB to make the change permanent. The question I have is there...

I believe I am understanding you Bob. And you are right, if I look at the control source for the two fields I do have a formula in there. So, my question would then turn to how do I auto-populate that input to the previous form's name selection so that information is stored? I do not want...

I am not sure where I went wrong. I thought this would work easy but it's not acting as I expected. I've got two tables - 1: Address Book; 2: Changes The Address Book table has all the data. The Changes table I just have 4 fields; Name (to tie back to Address Book) and Submit, Complete, and...