Search results

I'm using Access 2003. I'd like to have two levels of users that can access my database. Ones that can read/write the data, and ones that can read only. I have a network drive with a location that is accessible only to the read/write users, and a location that is accessible to all users. I...

I have a small database and I'd like to put the user documentation for this database on a form in the database. I was hoping to insert some sort of textbox like object, but fancier than the standard access text box. I'd like the ability to format individual words in a text box, the ability to...

I have a table, each record is information about a sample. Each sample belongs in one of several different groups. I want to mark the sample within each respective group that was taken most recently, and I want to do it by modifying a yes/no field using an update query. Attached is a...

I have a form that is bound to a table. One can select a record using combo boxes or using a list box. Each time I change the record I want both my combo boxes and my list box to reflect this change. Things work properly when I select a record by using a combo box. However when I select a...

I was thinking of using a subform in datasheet view to allow a user to select records on my form. I'd like something similar to a split form, but I'd like to have control of the shape and location of the data sheet part. I could also use a listbox, but I'd like to have all those sort and...

I have a form that is bound to a table. On this form is an image control. The picture property of this image control is set to a path which is a field in the table. When I navigate to new records, I update the image using the following code. Private Sub Form_Current() If...

I'm having a hard time deciding how to set up my class diagram for a database that keeps track of employee training records. I need to keep track of when employees attended certain courses. I also need to keep track of dates by which employees are required to take a course. Its also very...

I'm adjusting to visual basic after using Perl for a few years... it is difficult. I'd like to parse this text... 1200:3012-4130(1-560) 1208:3012-4130(561-1120) 1216:3012-4130(1121-1680) Into this table rline fstat lstat fchan lchan 1200 3012 4130 1 560 1208 3012 4130...

I have a form that I view in datasheet view. The record source for this form is a query. When I change the definition of this query, the change is not reflected in my form until I close and reopen the form. I have tried the requery function on my form but it did nothing. Any idea why this is...

I have been using the DAO.FindFirst function in order to find records in my database but it seems to be very slow. I am confused because it seems to perform at the same speed regardless of the indexes on my table. That is... rs.FindFirst (tape = 160 and ffid = 32451 and sline = 2286)...

I am importing large datasets into my database from text files. I would like to add records in a manner so that if they are new, a record is inserted, but if they duplicate of one of my unique indexes, they update the existing record. In MySQL I run the following query for each record and it...

I cannot import a linux text file into my access database using the following code... Open spspath For Input As #1 While Not EOF(1) Line Input #1, strline Can I modify my code to handle linux or windows text files? And a bit of background: I have a database where I will be...

I'm trying to improve my understanding of datasheets... I have a query that I saved in my Access application. I can see its SQL as a variable in Visual Basic by typing the following into the immediate window: ? CurrentDb.QueryDefs("TestQry").SQL SELECT Employees.EmpName, Employees.EmpNumber...

Hello, Is it possible to use a crosstab query as a subquery? I'm trying to do the following: SELECT * FROM (TRANSFORM Max(Expirations.DateRequired) AS MaxOfDateRequired SELECT Expirations.EmpID FROM Expirations GROUP BY Expirations.EmpID PIVOT Expirations.EventID) as XtabBut I get an error...

Hello, I'm trying to export a crosstab query from a form in Access to an Excel spreadsheet. Unfortunately the following code did not work: sqlquery = "SELECT * FROM AllPossibilitiesAttendance WHERE isSS" DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, sqlquery...

I am trying to insert multiple lines into a table using a Multi Select List Box. The best solution I could come up with was to loop through each selected item and then run an insert query for each loop iteration. For Each rownum In EmpList.ItemsSelected empIDval = EmpList.Column(0, rownum)...

1) Are there convenient ways to test code from a class module? Every time I try to run a procedure from my class module in my immediate window I get an error "Sub or Function not defined" 2) Is it possible to run a procedure from a class module outside of the class module? I'm imagining...

The following query works without a problem: SELECT * FROM ( SELECT Name, 99999 AS EmpNumb, 2 AS Origin FROM [SS Training] ) UNION ALL ( SELECT Name, EmpNum AS EmpNumb, 3 AS Origin FROM [JS Driving] ) However this query gives an error: "The number of columns in the two selected tables or...