I am trying to change the database I've built a little bit, so it would be easier to add more unit's if we need to. Currently the table design is set up as below
Part Number--|--Part Name--|--Unit1ECD--|--Unit2ECD--|--Unit3ECD--|--etc.
----Part A-------|-----Name A---|----9/9/99-----|----9/9/99-----|----9/9/99------|--etc.
----Part B-------|-----Name B---|----9/9/99-----|----9/9/99-----|----9/9/99------|--etc.
...
mswhiteside
Last Activity: Mar 25 '08, 06:14 PM
Joined: Jul 18 '07
Location:
-
Changing Database Format. Possible SQL Query?
-
Query Conditional Autonumber
Hello All,
I have a query that i need to have ID's that start over on certain records in the Table like below
Field 1---Conditional AutoNumber
IRM-------------1
1-----------------2
1-----------------3
2-----------------4
2-----------------5
IRM-------------1
1-----------------2
1-----------------3
2-----------------4
etc
i'm having some... -
Problem in a Form
Hello all,
i have a form in my database that i have put an After Update event into. everything works just fine, but it won't let me move to the next record in the form. anybody have any ideas to what would make the after update event do this? if i take out the after update event, then there isn't any problems whatsoever. -
Scroll Bar?
Hello all,
I have a continouous form that is very wide. i've got all of the fields as small as i can make them, but when you get out to the fields on the end, you can't see the beginning of the form, which has information that is needed to be seen at all times. is there a way that i can make it so that when the screen scrolls to the right, that the fields i want to stay visible will move right along with the screen? more or less... -
Mouse Pointers
Hello All,
What i'm trying to do is in a form, for a box, make it so that when the mouse is over it it is the hand, instead of the mouse pointer. I can't seem to get anything to work though. I can get it to show the hourglass, but haven't been able to find anything that would show the hand. Is there something that i could code into the on mouse move event that would maybe load a custom pointer if nothing else? -
Thanks for the quick response guys. The problem i have run into is that there are a bunch of people that need to get into the database, and most of them know that you can hold the shift key down to bypass all startup commands. Also i have discovered that people will just create a new database, and import everything, which more or less gives them full access. I got around this by hiding the tables through the code i showed earlier. This makes... -
Hiding Query's
Hello All,
I have an Access Database, that i would like to hide all of the query's, and preventing them from being imported by another database. I tried to use the QueryDef's in the same way that you use the TableDef's
( ie. CurrentDb.Table Defs("TableName ").Attributes=d bHiddenObject)
However, it won't allow me to hide the query's.
Anybody have any ideas? -
Anybody got any ideas?Leave a comment:
-
Power Point Presentation From Access
Hello all,
I am trying to create a database that would allow me to automate Power Point Presentations. The problem i am running into is that there are many charts that are included in many presentations. I have most of these charts in Access, but i haven't been able to find a way to copy the chart, and paste it into the Powerpoint object. Any ideas would be appreciated.
Thanks -
Copy Chart
Hi Everybody,
I am trying to write a code that will automate the creation of a power point presentation. There are some charts that i have in a form in Access, but i can't seem to find anywhere that has a code example of how to copy an access chart. Does anybody have any ideas on how to do this?
thanks -
Access Conditional Formatting
Hello everybody.
I need some help. i'm trying to use conditional formatting for about 6 different conditions in Access. what code can i use to make this happen, since you can only use the default conditional formatting for 3 conditions.
Thanks -
Conditional Formatting
Hello everybody.
I need some help. i'm trying to use conditional formatting for about 6 different conditions. what code can i use to make this happen, since you can only use the default conditional formatting for 3 conditions.
Thanks -
Thank you everybody for your responses. it looks like the tabledef code is doing what i was wanting it to do
Thanks a bunch!Leave a comment:
-
Hide a table
Hello Everybody,
Im Trying to hide my tables so that they can't be imported/linked from another database.
i've searched, and searched, and i have a question that i haven't found already asked anywhere. I work for a corporation, and have self taught myself access, and VBA. we have a database where i work, and my manager would like to share our database with other groups. the only problem is that certain people aren't allowed... -
Copy Chart From Database Form
is there a way to copy a Chart/Graph that is built in an Access form without print screening the page? -
Hide a table through Code
Hello Everybody,
Im Trying to hide my tables so that they can't be imported/linked from another database.
i've searched, and searched, and i have a question that i haven't found already asked anywhere. I work for a corporation, and have self taught myself access, and VBA. we have a database where i work, and my manager would like to share our database with other groups. the only problem is that certain people aren't allowed...
No activity results to display
Leave a comment: