Recent content by mapat

Thank you for your reply, but I would need to do this using only tables and not forms since that is the business requirement. Thank you.

Hello, I have tables A(student information) and B(student yearly information) linked by studentID field. I am trying to create a query in a drill-down manner that would display all fields from table A and when clicking on studentID on that same row it would display all fields from table B...

Thank you very much for your help. That resolved the issue.

Hello, I am using ACCESS 2007. I have a subformA inside the main form. I have the following 2 buttons: INBOX and SENT on the main form. The idea is that when clicking on INBOX or SENT the results displayed on subformA should change (looking at different records) depending on which button I click...

Hello, I created a temp "#ToPivot" table that holds the following values: ServerName Date CountHits ServerA 4/25/2011 4 ServerA 4/26/2011 2 How do I generate a table based on the above one that would look like this: ServerName 4/25/2011 4/26/2011 ServerA...

Permission Query - URGENT Hello, How do I query a list of users and permissions they have in SQL Server 2008 such as SELECT, INSERT, etc. Please I need this as soon as possible if anyone can help. Thank you everyone

Hello, I want to be able to add a button on a form to scan something and save the scanned file onto a predefined location on the PC. I've looked into WIA but I read that it is compatible with certain scanners only and in case of using these scanners I would be able to use certain OSs only such...

I have a main form "MainA", and 2 sub forms "SubB" and "SubC" on it. From the Current Event of "SubC", I want to requery or refresh "SubB", and this is when Access tells me: "can't find the form SubB referred to in a ..." This is my code on the On Current event of SubC: Private Sub...

Hello, I have a main form and in it, I have 2 subforms (subformA, and subformB next to each other) which are both linked to the same table. SubformA shows only 2 table fields and is seen in Datasheet View, and SubformB has basically all the table fields and is shown in Form View. When I...

Wow, Thanks. Based on your last syntax I realized that the ORDER BY clause was before the LIKE word. Now it works. Thanks everyone again

Well, no error message, the List box continues to be blank. I pasted the same code on to the "On Lost Focus" event and once I click out of the txtfield, it behaves the same way. Also tried storing the "txtfield.Text" value on a temp variable and used this var on the syntax instead and it does...

Thanks for your response. This syntax is still not working.

I do want to change the RowSource on every key stroke. I've tried both syntax and neither one of them worked. So I'm still stuck. Thank you.

Hello, I have a 'txtfieldA', and a 'ListBoxA' which is supposed to be linked to 'tableA'. tableA has the following fields: PatientID, PLName, PFName. Now as I type in the txtfieldA the person's last name I want that record to show up on the 'ListBoxA'. Example: If I have 3 Smiths on my table...

On a report I have 100 schools. I want to display students for each of these schools. The report is working but whenever a school finishes its student list, I want the next school to be shown on the next page (with the school name and ID). Now if school A finishes the list on the middle of the...