Search results

In the private school where I toil, I have developed an Access application which is widely distributed as an executable. A student recently "discovered" a security hole in our LAN that allowed students to access the shared folder containing the Access database used by the distributed...

I have an application I have built for our private school. The application uses shared databases and is installed on workstations through the school. The database is stored on a public file on my computer. Recently I added a table to the database and tested its functionality on my development...

I have a report that shows a schedule for a student. It draws data from a table of students and a table with class schedule information and a table that is used to sort class records by weekdays. I have added a table of static text descriptions for a list that appears on the schedule. These...

Perhaps you are right, but here was my stumbling block: To calculate a quarter GPA on the query of the source table (Class/grade records) I would need: If Class is type "m" IIf([First Quarter Grade]<60,0,IIf([first quarter Grade]<70,0,IIf([First Quarter Grade]<80,1,IIf([First Quarter...

The process of calculating GPA is very complex in our school because we serve special needs students who may be in one of four categories of instruction, each with a GPA modified calculation, for example, an 'A' is a special education course (clearly identified on the transcript) does not equal...

This problem is self inflicted. My report is a school transcript. The data is drawn from a make table query. Each time the report is run the table is re-created with the data for the student in question. Not all class records in the table are showing on the report, and the condition of the...

Well I am embarrassed to say I can't figure out how to check the Type of my module, but the icon indicates it is not a Class module. The module is filled with functions that I have cribbed for my application and I am calling them successfully from my forms' code. But the forms I am making the...

I am developing a small application and I have public functions and variables defined in a module. My first feature works well: Form1 opens Form2 which puts a value in pubVar1. Form2 opens Form3 which uses the value of the public variable. I am having a problem with my second feature using...

I am writing a little swipe card application. My "Main Menu" has an event to allow the user to swipe their card. The form I created to prompt the action is very simple with only one label on it. When it is displayed, it is blank. The only success I have had is to set the Docmd OpenForm...

OK, I owe you half my paycheck again. Its a shame that I'm a volunteer.

As usual Bob, you are right on the money, but I can't find VB to do that, I.E. a DoCmd method.

I manage a distributed application with split databases - multiple users, one server. I have added a function to the application that requires the deletion and re-build of a table through a make table query. The test version of the application does not create linked tables in this process...

I appreciate the interest. Here is an example of the VB.6 code that does not work, this is the function to find the smart card reader: Public Declare Function SCardListReaders Lib "WINSCARD" Alias "SCardListReadersA" _ (ByVal hContext As Long, _ ByVal mszGroups As Byte, _ ByRef mszReaders As...

I appreciate all of the discussion on this problem, but I am still having an error. I have two projects for this smart card application outside of Access. VB.NET version works and VB.6 does not (outside of Access). When I crib code from the VB6 app into access I get the same result, it does...

Thanks for all of the input. I may have a solution but it takes me into an area I am unfamiliar with. The .Net application I am using came with an object library that I can reference in Access. I can select the object library in the object reference screen and see the objects and methods it...

The version of Visual Basic in my Access 2007 is 6.5. I am adapting some code for smart card processing from Visual Basic 2008. I am getting an overflow error on Integer variables, here is an example: PublicConst SCARD_PROTOCOL_RAW As Integer = &H10000 This works in the 2008 compile. If I...

Fantastic! How can I thank you for doing so much work on my behalf. My process is working perfectly. Thanks John

I would use the SQL if I could, but the statement seems to exceed the size parameters in the VBA editor. Here is the statement: (one of three): I tried breaking it up into multiple strings, but I could not get that to work either. I would like to find a way to run the query from the access...

I'm new to DAO and walking through my manual. I want to use the execute method to run a query in VBA (the SQL is really big), but I can only find a description of how to create a QueryDef "from scratch". Can I create a QueryDef from a query which exists in the Access workspace? Any help is...

I should give Bob Larson half my pay. In the process of creating a sample database to illustrate my problem, I solved it. It pays to get simple. Thank you