Search results

Hi My Access 97 application is on our sharedrive. But my problem is whoever access that database CurrentUser is always ADMIN Why is that? How could I actually fix that so the user on the certain machine would be captured? THanks

Hi I want to be able to reload (or requery) all currently loaded forms? Any suggestions? Thanks

On the form_activate i have an error trapping routine What i want to do is if the certain error occurs, I want the form to stop activating ( in other words, form wouldn't open) Please suggest a solution. Thanks

Hi I have a form for the record modifications. What I want to do is if the record is being modified, I want that another user wouldn't be able to open the form for the modification of the same record Is this possible to achieve? Thanks

the operation you described will skip the field but I need to extract the part of the field. The field in the spreadsheet has Lee, John - when importing I only want Lee. How can I truncate that field?

Hi I have a spreadsheet i need to import. One of the speadsheet's column contains LastName,FirstName separated by comma. I only want to import the last name from that column Please help to solve this problem, Thanks

Hi Is there a way to code the process of compacting the database? Thanks

Hi I have a huge listbox on my form. Depending on how the user sorts it, list always has different number of the rows in it. How could I print out the current content of the listbox? Thanks

thanks a lot i figured that i can't open a recordset that prompts for the parameter. so what i did is i first ran the query, put the result into the temporary table and then opened that table as a recordset thanks again good luck

No, the Access Table only needs to have a few tables from SQL table What is make-table query?

Hi I am not experienced in database technologies, so please help me. I have an access table that is just a copy of the sql table resided on the SQL Server. Once in a while, I would have to update that Access with changes made to SQL table. What should I do? Is it better to copy the...

Hi I am trying to open the recordset: Set dbs = CurrentDb Set rst = dbs.OpenRecordset("bill1") And get an error "TOO FEW PARAMETERS" "bill1" is a query where I prompt a user to enter the criteria. What could solve the problem? THanks

hi I have the table RecordID Transit AssetType 1 12 1 2 12 1 3 13 1 4 12 2 I need a query to count how many record belongs to what transit So based on this example I would...

Hi I have a table called 'CONFIGURATION' that has a numeric 'ModelID' field. How would I lookup the max value of that field from the vba code? Thanks

Hi I am looking for the ways to undo the changes made to the field on the form. I tried Me.Undo but it will undo all edits on the form. Please suggest anything to solve that problem THanks a lot

Ok Could I also check if the file already exists?

Hi I export some data into the excel spreadsheet...so what I want to do is to check it the file is open before I do my transfer Please suggest. Thanks

Hi I export my Access table to the excel spreadsheet...One of the fields is quite long, but when it all is transfered to the spreadsheet, the cell's width is fixed. I know you can change the excel cell's width by simply dragging cell's border to the right...but...can I export the table that...

Hi On my form, I use this date function Option Compare Database Option Explicit Function AddWkDays(vardate As Variant, numdays As Integer, _ pexclude As String) '******************************************* 'Name: AddWkDays (Function) 'Purpose: Simple, non-formula method of ' adding...

Hi I have a report that I export to the text file. The problem is I the first line blank in my txt file. Why would that be?