Search results

I've been looking without success for an answer to what is probably a stupid error I am getting. Recently upgraded to Office365 and methods I used with Access 2000 are not working here. My form has a combo box for a user to select an account number. I want to use that selected account in a...

I have a little experience with Access - but I was really surprised how well the web app organized my data. My big issue now is to figure out how to do the same type of thing in a regular dbase without using VB (I'm terrible at that)

Thanks .... I think.. HA! I really liked the way the web app displayed the data - without the queries/etc needed. Guess I'll just have to get to work designing something myself .

So we have just updated office suite at work to Office 365. I was asked to put together a quick dbase that would pull in information from a few different places to give our telephone support people some historical data. That was easy enough to do, but when I went to create a new dbase I saw...

I've not done anything in design view on this form other than trying to look at all the properties to see if any 'period' was accidentally put in or even looking to see if any spaces were put in between an argument (macrogroupname .macroname vs macrogroupname.macroname) This all started about...

My DB has been running great for years. Then recently I've started having an issue with it I cannot seem to solve. Hoping someone here may know what's going on because I cannot find it. I open up a form that views inventory items and click a button to add a new record. Viewing the items...

I did find this example. About half way down the page it explains using a make table query to overcome the not updateable hurdle. It describes exactly what i've done; yet mine continues to be unupdateable. Wierd .... Code from my form's query that isn't working: SELECT...

So I've worked myself into a small bind that I've not been able to figure a way out of. I {had} a form working just how I want, allowing the end user to see a set of records and make changes as needed (basically all they do is update a flag). However, I wanted to highlight certain records that...

Worked like a champ! Thank You

plog I think I understand were you are going. I tried adding this to my query: reportday: IIf(Weekday([reportdate])=1,2,Weekday(Date())) Just running this to test making Sunday a Monday. Two problems I see. 1st, there is a problem in my line above. Everything is getting a reportday of 2 -...

I run a daily trouble report but I am not getting weekend troubles looked at because the report only looks at today's issues - Query uses =DATE() as a criteria. I want to run a 3 day report if today is Monday. I have read through several threads here, and other places, but have gotten nothing...

Again - this is an old thread - but I wanted to post a solution to my problem that I was able to come up with today... The clue was that if I went into design view and back my subforms would update accordingly. So, where Bob said above to add a line of code to transfer the combo box value over...

Just realized. If I select an item in the combo box, go into design view for the form, then back to form view, the data will update in my subform. Thought I would update my above question with this information - maybe it's a clue I'm not seeing?

Hope this works - quite an older thread but I am having some difficulty in getting parts of this to work. Essentially I have set this up the same way, and if I open the query directly or the form made from the query, it works like a champ. But, my combo box is on a form and the subform (from...

I could swear I've read how to do that, but never personally done so. If I can find the site I read it on I'll post a link for you.

WoW I am blind today.. So I know now where to look/set conditional formatting. I just now need to get it to work. My form displays Account, Status, and Send. The subform displays date and notes. What I tried was: [Form]![account tech notes].[notes] Is Not Null and set the formatting for that...

This is what I was running into, but caught a video (about the 6:20 mark) that says it is wrong. Access will tell you that it isn't possible, but you can override it. I just tried it and it worked for me. Still haven't found conditional formatting, but I'm in an archaic business and I'm...

I am pretty green with creating forms. I usually just grab tables and run queries to get what I need - so I had to look up continuous/single/etc formatting explanations. I hadn't considered changing colors. But that would work. Right now I've got a list of accounts and each has a button next...

Kind of but I think it is written a bit differently. I normally will just link the table, then I can use it without actually storing it twice.

Not sure if this is possible - or what may be needed to even determine if it is. I've got a form that lists anywhere between 5 and 20 accounts that require some type of action on today. On this form, I have a button that opens a subform to show any historical notes for this account. This...