Search results

Thanks, I think that's the only choice I have. :)

I think you're mistaken about my example. The are only two forms involved. When I open the new form, I'll add a new record and fill in the roomNumber and do more procedures. If I do it through the onClick event, I have to do 60 onClick events for 60 buttons. I simply want to avoid having to do...

Yeah, thanks from me, I've been looking for the same information and most answer I found were either too complex or didn't work. I tried your and it works like magic, now I just need to find codes for hiding the navigation pane. :D

Well, the users have problems with combo box, and for visual reasons (the layout of the rooms) I want to use button or anything that they can click on to take them to the checkIn form and fill in the roomNumber. My connection's too slow to upload a file, so here's a sample code of what I would...

Hi, I have a form with many buttons, one for each room, and when I click on the button, it will open another form, go to a field (roomNumber) and enter the room number in that field. I got the code for the action down, but I'm stuck at how to program all the buttons on the form (the form...

I would think it's better for you to use a query to draw out that data whenever needed, instead of creating another table. But I don't fully understand your problem, why you wanted to create another table and how you want to display the data. BTW, using queries would resolve your second problem...

How do you hide the database window? Right now I simply use the navigation pane to hide all the tables, which is kind of a pain when I have to go in and change some data.

Hey, I have been manually making backups (copy and paste) of my BE database, but would like to have it done automatically for me, does any one have any pointers as to how that can be done? Thanks.

If you made a workgroup file, I would try what Singh400 suggested with the file too. I had the same problem once.

Thanks, I'll get right on it. :D

Hi guys, I'm wondering if it's possible to open other programmes from Access? Is it possible to make my access software connect to my scanner and save the newly scanned pictures with the recordID generated in access as its name, or the reverse, have the software retrieve the name the picture...

I'm making it for a point of sale, so I'm concerned about the people who need to use it might fiddle with the data. But I've been reading more on user and group permission and it might answer what I need. I couldn't understand it before when I came across it in articles because it turns out...

Thank you for the pointers.

Hi, I'm new to Access, and I wonder if you wonderful people can explain what are some of the ways I can create users and password for my database. Is there anyway I can prevent people from copying the database from a computer and use it on another computer? And lastly how do I create a front...

I found out it's the setting of the database. I can change that through the Microsoft office button. I feel so stupid, it's always after I had asked the question that I find it's just a simple one click solution. Thanks guys, for the replies.

I'm using Access 2007. Basically I can't open two objects with the same source together, or even objects that has relationship to each other with fields already displayed in one object. Say I have formA with some fields from tableB, if formA is opened, then I can't open any object that is...

Hi, Not sure if this is not a stupid question, but when I try to open two forms with controls that have the same underlying control source, I encounter a message that say "the table is locked and cannot be malnipulated pregrammatically", or "the table you tried to open is being used, please...

Hi, I've created a table that has a date field and many locations field, to show when a location is taken up. In each location field, there's three list box options: empty, sign in, sign out. How can I make it so that when I choose sign in, the record will stay in "sign in" as I go down the...

Never tried it myself, but maybe an append or update query might do that for you? Try making a query from your normal table. In the new query, calculate the value to want. Create another table with an extra field for the calculated value to want to add in. Use an update query to populate...

Hi, I have this problem that's killing me. I have created a splitform that allows me to add items I'm selling, and allow me to see the new records I've just added in a datasheet view just beneath it. Now I need to select these new records that I've just added (the form is in add mode, so it's...