Search results

Column3 has values 1-5 (numeric, yes). When cmdbtn1 is pressed I want the listbox to display all records where column3 = 1. When cmdbtn2 is pressed I want the listbox to display all records where column3 = 2. and so on. Also, I would like the listbox to default to Column 3 = 1 when the form is...

Hi all I want to show/hide records in a listbox depending on which command button is pressed. I have 5 command buttons and column 3 in my list box refers to each of these command buttons (1-5). How do i display the records in the listbox that match that ID/command button? I was think of...

Hi all Having a stupid little problem - The currency and decimal places are not showing up my listbox. In the table that the listbox is based on the field is set as currency but its not showing up, any ideas? Btw, i looked at other similar questions but someones posted a db that was supposed...

got it! thanks for that, i didnt notice...

Thanks. When I put it in with the other code in the current event when i open the form it says Compile Error: Block If wihtout end if. Whats that all about?

Hi all I have a form that has two images on. They are set to visible=no. I want them to be visible if a check box is ticked for each: If Me.Vegetarian = True Then Me.ImgVeg.Visible = True Else Me.ImgVeg.Visible = False If Me.ContainsNuts = True Then Me.ImgNuts.Visible = True Else...

Hi all Im sure its pretty straight forward and ill kick myslef but can someone tell me how to select a record in a list box and then it displays the rest of the info of that record on the form... Thanks

Hi Neil Im not sure what you mean by my tone? This is not yet an assignment but we were asked by friends of ours to help them throw some ideas together. They own restaurants and saw that someone has done something similar in the U.S. that they liked and wanted to try to look into. They wanted...

Those were my initial thoughts also but they argued that if the user interface was good enough then it should be easy. Also a "notes to the kitchen" box for any notes e.g. "i want the steak medium-rare". It was also argued that the costs of the system would be outweighed because less staff...

I understand what your saying and I have checked out some of those. They give me a rough idea of table arrangement but not sure it suits if customers are ordering themselves. For example, they would like an interactive menu then be able to add that item to the order (like a shopping basket...

Hi all I have a friend who owns a restaurant and wants to create an ordering system/database for a restaurant where customers order their own food they have asked me to give them some ideas. As far as table and relationship design - can anyone suggest anything or give me ideas to start. I was...

Hi Guys AS you can see from the title im having a problem that the print margins in IE reset themselves everytime a restart my computer. I want the left margin to stay at 0.75 but it goes back to 0. Can anyone help? Thanks

Hi All Want to try to start teaching myself PHP and MySQL so I can start to make database-driven dynamic websites. Had a search here alread but just a very simple question to get me going and hopefully a simple answer... I understand that for what I want to do i need Web server Software...

Hi Guys just been asked a question that i didnt know the answer to (no change there then! lol) they were asking about making an online ticket / box office system website (much like ticketmaster / see) does anyone have any experience or advice or can anyone point me in the right direction...

Thanks, it comes up with the application, here it is named "system" (different to the application name). its type is Microsoft Access Record-Locking Information. Opens with: unknown application. size: 64 bytes (64 bytes). this is the only file it finds. however when i find the file on my C...

where do I find that out? on the appliactions properties it says Type of file: Application Description: StartAccess Application Size: 468 KB (479,232 bytes) StartAccess_2002.exe

Hi all, quick question. someone has shown me an application/software that is made on MS access. if i go to the application properties it says "start access application" etc. this is a database that required installing like an individual application before it can be used. My question is, they...

Hi Guys Tried looking up audit trials etc but cant find what im looking for. As mentioned in a previous thread im trying to make a db for a letting management agent. I need to create a history log or similar for each property that shows a note for anything that get done to that property / on...

Hi, thanks, Ye that points me in the right direction but two questions; how do i get this on open form to run in the background and what will the code for it to check the reminders table? ill look into the send object function to get more info. thanks james

Hi guys, Have searched archives for "reminder" etc but can't find what I’m looking for. I am designing a lettings management database. I want the database to e-mail 3 or 4 people with a reminder when it reaches a certain date. I.e. Property X needs a new gas safety certificate to be done on...