Search results

great! the popup property works perfectly! Thanks!

Hi there, I want to setup my Access 2007 database with the new tabbed forms feature, i.e. I want most forms to show up fullscreen. However, some forms should be shown in a window. How can I set this up? Here is a sample that illustrates what I'm talking about...

Thanks georgedwilkinson! I think it is the standard case that Access 07 disables VBA content so this form will never run, right? I'm looking for a way to show a form if VBA content is disabled. The reason I want to do that is to give users instructions on how to enable VBA content. An example...

Hi *, I recently found an Access database that shows a form at startup ONLY IF VBA is disabled (user has to click on 'Options' -> enable this content). Unfortunately, I'm not able to figure out how to implement this feature in my own database. I know how to setup a database with a static...

Hi there, I have a couple m:n relationships in a database. Now, I was wondering whether (1) to create a new primary key in the connecting entity or (2) to use the combination of the 2 FK as new combined PK. The attached screenshot shows option 1. What option would be better for good query...

Thank you! The forms work perfectly now. Seems like there are 3 parts that have to be modified in order to make the db compatible with different time formats: (1) Line100 in modCalendar: rs.FindFirst "InputDate = #" & Format(myDate, "YYYY-MM-DD hh:mm:ss") & "#" (2) Line 43 in...

Thanks for the sample! It looks like I can actually use a lot of it! One more question about the input2000 database: When I try to insert a new entry into the database, the system gives me the following error message: Syntax error in date in query expression...

Hi Banana, I do need the user table for application reasons. It has nothing to do with user security. So yes, I agree with you: a common user table would be the best way to go! The question now is whether I can accomplish this by doing what I described under (1) or (2) in my initial posting.

Hi *, I'm in the process of developing a new internal project controlling. Part of the system is a (1) already existing system and (2) an Access front-end. The already existing system uses a MySQL database. The ERD is attached. Now, I need to integrate both systems and I have a couple...

Hi *, At the moment, I'm working on a data entry form that lets the user input data in a calendar format. I attached a screenshot of the design I'm thinking about. As you can see, I would like to be able to present a view of the current month. Here the user should be able to directly insert...

Hi there, I got a little data transformation problem: I have got a source table: ID 1 2 3 1 x y z 2 xx yy zz That I wanna transform to the following format: ID ID2 Comment 1 1 x 1 2 y 1 3 z 2 1 xx etc... The problem is, that I need...

Thanks. Sometimes it can be so easy ;)

Hi *, OK, still new to Access so I apologize in advance if that is a dumb question ;) I have a table "survey" where I wanna store number values (0,25,50,75,100 respectively). The user is supposed to use a form to input the data into the table. For this purpose, he/she is supposed to use a drop...

Thanks Bob. I figured that lookups are prone to produce failures... but I have to work with this shitty Access db... any ideas how I can get the data into the db? Steve

Hi there, I'm pretty new to Access so I hope this question is not to simple/stupid ;) Ok, I have an Excel Worksheet that I want to import into an Access Table. The column headers are identical! The only problem is: - the Access table looks up a couple of the columns from other Access tables...