Search results

how to read value from a form in a report Thanks alot, Groundrush and Banana for your support. Yep, i got it. But i have another tricky question here and wonder if you could help me here. I'm not sure if this is a good practice type of coding. In the report, I have a code that's looking up...

Hi, I was wondering if anyone might be able to help me here. In the report, when there is no data, the "error" comes out on every fields. My question is For example in a table called student studID FirstName LastName Address Course 1000 Michael Fox 34...

Hi, I was wondering if anyone might be able to help me here. I was trying to write up a technical report for the Access database i built. Are there an easy way of exporting all the tables with their attributes in Access? For example, in the student table, ID FirstName LastName ... Thank you...

Hi Adeptus, It works well with the description. AMO01 Operations and Optimisation P AMO02 Planned Maintenance P ECO01 Operations and Optimisation AMO01 ECO02 Planned Maintenance AMO02 When i selected ECO01 from the listbox, the report...

Hi Adeptus, Thank you for your reply. > Have the Description as the listbox's Value field, and the report's filter criteria Sorry i'm a bit slow to catch that. Are you saying to have the description as the listbox's bound column. please correct me if i'm wrong. But i'm not sure how i get...

Hi, I was wondering if anyone might be able to help me here. I have a form that has a listbox that has 3 columns showing up a list of project outline for example ID Description Structure AMO01 Operations and Optimisation P AMO02 Planned Maintenance...

Hi Shadow9449, Thank you for your reply. "created the Access application with client/server in mind". OK..., but unfortunately, when i created the database, i wasn't aware of all of these client/server stuff before. Hence, i did not have client/server in mind. Is that mean i have to start it...

Hi, I was wondering if anyone might be able to help me here. I'm very new to SQL server and has been asked to convert microsoft access database .MDB to SQL server. In another word, i'd like to migrate access to SQL Server. It's not a huge database. The size of it is roughly 6MB. The reason for...

Hi, I was wondering if anyone might be able to help me with this. I was trying to get a filedialog popup windows to show up so that user can enter a filename for saving purpose. The following is the code i got from Access help but didn't work. Private Sub CM_openfiledialog_Click() Dim...

Hi, I was wondering if anyone might be able to help me here. In a table, i have the following data. ID ProjectName NA_ID NA_Site_ID 1 Team30 3000 2 Microscope Team31 3000 Then, in a form, i have a listbox that displays everything...

Hi, I've got a table that has fields as follows studentID, ..., 2005/6, 2006/7, and so on. My question is if i know the studentID but i don't know whether it'd be 2005/6 or 2006/7 because it's based on the current year and i want to make it flexible enough. I've got the following code...

Hi, I was wondering if anyone might be able to help me here. I have a form that has a button called export to excel. I have tried to export report to excel and it works. However, i've been asked to produce an excel file that looks like that in the report in the access. Because in the report...

Hi, I have a form that has a button to export access report to excel. I've got that button working. It creates an excel file based on the access report. However, i want to do something more. In the form, i also have a listbox showing records filtered by a couple of comboboxes. So what i would...

Hi, I was wondering if anyone might be able to help me. I have a form and it has listbox displaying a certain number of records and it also has a button "Print All". What this button does is it would print to the report whatever on the listbox. My question here is because i'd like to let user...

Hi, I have a question in regards to the mousewheelonoff. I've the code from the internet and it works fine. The mousewheel can be set off or on. Great. However, it has to have the mousehook.dll sitting on the same folder as the database. My question is is there any way of incorporating this dll...

Hi, Is there a way of writing a code to make the database window shown or hidden? because what happens is that in my code, i have what's called "allowByPassKey" that you would only get to see the database window if you press & hold on to the shift key as the database gets loaded up. What i'd...

Hi, Ghudson I have just posted a new thread which is related to the control Box X button today. I should've posted it in here. what an absent minded i am. Thank you in advance

Hi, I have a question on the Control Box X Button which is right on the top right hand corner of Access database. I'd like to customise it in a way that if user by accident, click it, it'd ask the user if they want to quit or not. If yes, then close the database or else, leave everything as...

Hi, I have a question related to duplex and wonder if you might be able to help me. In a form, there is a checkbox with label "duplex" called CK_Duplex. User can choose to have duplex checked or unchecked. the following is the code for the report. Private Sub Report_Open(Cancel As Integer) If...

Hi, I was wondering if anyone might be able to help me here. In a report, is there any way i can set a size for a textbox? for example, there is a field in a table that has value of SEPP (Air Quality) EPA licences EPA buffer zone document, AQ286 However, in the report, the textbox called...