Search results

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...

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...

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...

Hello, I have ACCESS 2007 (fe) linked to SQL Server 2008 (be). Currently, all the users have the front end on their local drives and that's what they work with. I want to have a main front end on the server and give the users a shortcut to that same front end, so everytime I have to modify the...

Hello, I thought I could set up the "Record Source" property of a subform from VBA. I have a main formA, and subFormB inside formA. When formA loads I want the "Record Source" of subFormB to be linked to "queryA", but once it loads if I press a button inside formA, then the "Record Source" for...

Hello, How come when I run the following batch it gives me an error? GO CREATE PROC dbo.sp_FixIndexFragRebuild @table varchar(40), @index varchar(40) AS BEGIN IF (@index is Null) ALTER INDEX ALL ON @table REBUILD ELSE ALTER INDEX @index ON @table REBUILD END GO...

Hello, I have a problem. I have an ACCESS2007 front end linked to a SQL Server 2008 back end which resides on a server. Somehow the primary key of a record in table 'A' on the back-end got corrupted. For instance, the record key is supposed to look like this "4NYC004571" and it looks like this...

Hello, Why is it that after I compact and repair an ACCESS2003 back-end file, and then look at the ER diagram, duplicate tables show up? This is preventing some reports from running. Is there any tool to fix this? Thanks everyone

Hello, Why is it that when I run the report from a front end, when my back end was an ACCESS file it would take 2 seconds to open, and now that I have a SQL Server 2008 back end (with same tables) it takes 5 minutes to open. The strange part is that the query that drives the report runs in 2...

Hello, something really weird is happening with the db. I have an ACCESS 2007 front-end linked to a SQL Server 2008 back-end. All the users have the same front-end on their PCs. I have 2 tables Guardians and Students which are linked with a 1 to many relationship starting from Guardians to...

Hello everyone, All of a sudden all the fields for a specific record on a table showed up with the ####### symbol. Is there any way to get that information back? Thanks

Hello, I have just finished importing an ACCESS db (back-end) to a SQL Server 2008 db. My front-end is ACCESS and the back-end is SQL Server. When I would fill in some txt fields on a formA, another formB is supposed to open. This used to work when the tables were linked to my old ACCESS db...

Hello, after I compact and repair my database, a copy of a specific table (that's already on the diagram) pops up on the relationship diagram with the same relationship as the original table. This is causing the program not to work properly. Can someone give me a hint on this? Thank you very...

Hello, I added some text fields to a report. These have the control source linked to a table, and some are blank and some are not. Now the problem is that when I "Print preview" the report, it shows the blank spaces from the blank fields. Is there a way to fix this so the blank spaces don't...