Search results

** Additional Note: Could I possibly just have a field in my main form that pulls data from another table? Warning: bad with code** I'm not sure I'm looking at this correctly and have tried to figure it out (For about two weeks now). I really hope someone can help with this. I have to add a...

Thanks a lot CCox. What I actually ended up doing was adding a 'Date' field to my table and then did a sort on that. This indirectly affected the order of my months as well. Hope that will help someone!

Sorry for my ignorance, but what do you mean by VB Help? I've created the Calendar so you click on a drop down and it populates that field. I can't for the life of me figure out how to populate other fields with that field's month, year and day of week. I'll keep researching but any help or...

This seems like it would be a simple thing to do but I can't seem to set the properties for a chart (that I inserted into a form) to display the values in that form. The wizard makes it sound like it is very simple and all you have to do is show which fields in the form are related to which...

Sorry for my ignorance, but what do you mean by VB Help? I've created the Calendar so you click on a drop down and it populates that field. I can't for the life of me figure out how to populate other fields with that field's month, year and day of week.

I have most of my db set up and part of it is created so the user will go to the form "View Stats". On this form is a list of stats they can view through reports and pivot tables. What is really strange is that for the user to view these, they have to minimize all of the forms first. This...

Worked! I did hold the Shift key down when I opened it, but what I was forgetting to do was hold it down again when I hit Enter after typing in my password. I found the explanation here on the MS website: "If you used the Startup dialog box (Tools menu) or created an AutoExec macro or an Open...

Worked! I did hold the Shift key down when I opened it, but what I was forgetting to do was hold it down again when I hit Enter after typing in my password. I found the explanation here on the MS website: "If you used the Startup dialog box (Tools menu) or created an AutoExec macro or an Open...

That didn't work. I still have the logon screen I created and then all that opens are the forms I created....

I'm not very good at this program - as you can see. But basically through the "Startup..." button in Tools, I changed the view when you open the program so that you can't see any of the back end. I wanted to apply this to other users, but now when I log into the database, I only see the forms...

I've looked and looked and am afraid that I didn't find this because it's not possible... The forms in my db are not the clearest, but one way of simplifying it for the users is to have them click on the calendar icon and then have a few fields automatically populate with the selected date's...

That wasn't working for me (but thanks a lot for the suggestions), however I created a very TEDIOUS work around. I am not a coder at all, but I figured out a way to do this. 1. Create the command button with the grey 2. Copy the code from this button (Design View > Rt click on button >...

Is this possible? I can't seem to find this q anywhere here so I thought I'd post. I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey. Is there anyway to change this? I right-clicked and tried...

Is this possible? I can't seem to find this q anywhere here so I thought I'd post. I changed the colour of my form to white, but the Navigation Buttons at the bottom and the command buttons that I 've added stay at the default grey. Is there anyway to change this? I right-clicked and tried...

That worked - thanks so much! Sometimes it's the simplist thing, but you never know. Have a great weekend!

Up until yesterday afternoon, I was having no trouble adding a command button, but then all of a sudden I was unable to do this. I'm in the design view of a form, and then using the toolbox, I add a command button. The square button appears on the form, but the dialogue box that walks me...

I have a report built off a query that shows the monthly totals of sales for each location. At the end of each group of months (the year's months) there is a SUM, and then the next year is listed below that. How do I change how my months are listed? They appear so randomly. The first year's...