Search results

Thank you so much for your suggestions. I've tried following the first part, but I then received errors in the link with my subform as the comboboxes are unbound and the subform won't allow me to list master/child fields with unboung controls. Also, if I remove the record source from the top my...

[Solved] Subform won't load from combo box selection--need to load so can add record. [Solved: Thank you to CJ London for his help :D] Hello everyone and HAPPY FRIDAY!!! I haven't found any solutions that work for me so I'm seeking help from you. Anything you can offer me is much appreciated...

This worked for me too! Thanks!!

Thank you for your response Bob. Yes I had noticed it wasn't built in... I was just claiming it should have been lol! I had already ran into Peter's Software option but unfortunately I'd have to download an .exe file. Because I'm at work (where I need it) though, I am blocked from such...

Thanks for trying, I also had already tried that... don't why but it didn't work for me either... I just can't believe this isn't a built in feature, almost seems like a no-brainer to me, geez lol.

Thanks for that, but I'm not just trying to maximize the window (that part's easy lol) I'm trying to center the content within the maximized window... something similar to CenterIt and Shrinkerstretcher but using VBA code and not the .exe files... I'm sure this is possible, but it's just a...

Try putting <= CURRENT_DATE as a criteria in the date column of your query for the report.

You're welcome! :)

I entered a function to hide the Access background so that only my pop-up shows to the user. Forms I created are pop-up and centered properties are set to yes. The DB file has been changed from tabbed to overlapping as well. I’d like to maximize those forms/reports and have the content center...

Great news for anyone searching for this same issue!!! I believe I have stumbled across two possible solutions: 1st: Open up the table in design vew, for every text, memo, or hyperlink column that you want to exclude blanks from and only count them as null change the 'Allow Zero length'...

I will have over 350 users, each of which manage about 30 different records. The information within the records is updated fairly often. If there is text in one of the fields that I see is incorrect, I will delete it so that they can update it later with the correct text needed. If I delete it...

First, thank you so much for your reply :) The default value: I don't think would work if the field has already had information but then deleted. Please correct me if I'm wrong, but I believe once the field has had info, it wouldn't return to the default value? Inputting this for each of my...

SOLVED--SEE BELOW TRAFFIC background of what I'm trying to accomplish: I have set-up a column in a query to count the amount of null values for each record. However, when a field has information and then is deleted, that field is now read as blank (or 0 value) instead of null and my count is...

This was driving me crazy until I figured out a simple solution. I figured if it drove me nuts there might be someone else who needs this info. Background: I have a survey in which people rate items from 1 to 10. I've set-up my report to calculate how many 1's in field 1, field 2 etc. and how...

I'm also using Win XP/ office 2007. I downloaded the updated file 1.6.1 from utteraccess here http://www.utteraccess.com/forum/Who-s-Logged-Who-s-Con-t1897146.html&p=1897146#entry1897146. Since the 3251 error I received was looking for less than 128 characters filepath, I changed some things...

I also have 2.1 library but my error is different than yours LadyDi. My error says 'Object or provider is not capable of performing requested operation. (3251)' After googleing the error, it looks like any file name longer than 128 characters is what causes the return of 3251 error. I tested...

Thanks for the info. Do you recall where you gathered the "how-to" to set all that up?

I am using 2007 and have my own security set up from Dane Miller's Advanced Custom Password DB (allows button access using Groups of Users instead of having to grant access to every single user). I'm trying to accomplish the same thing as you in figuring out how to capture the user's log in ID...

Just incorporated it into my database... so far works great! Thanks for the suggestion Bob :)

Thank you for your suggestion Chris, as many tags as I'd have to create for each button I now have to agree with you (I was thinking 50 and realized I will need almost 10 times more lol!). I'll begin the research on cmd access from a form. :)