No announcements
-
0 Voteshow can i copy current record data before remove him to other table
hi guys. i have 2 tables his names old_table, new_table and ...Unanswered | 2 Replies | 25 Views | Created by KORG.Pa3x - 4 hours 19 minutes ago | Last reply by KORG.Pa3x - 3 hours 50 minutes ago
-
2 Votes
VBA ACCESS PROBLEM - VBA PROJECT CANNOT BE READ
This problem started this week in one Windows 7 machine with Office 365 on Monday and then emerged in 3 more computers with Windows 10 and Office 365. After a computer restart the ACCDB and ACCDE ...Unanswered | 9 Replies | 110 Views | Created by Aggelos Sakaloglou - Friday, September 29, 2017 9:47 AM | Last reply by Aggelos Sakaloglou - 4 hours 4 minutes ago -
0 Votes
Update a Date text box
I have a text box on my main Page, but if the database has not been closed down and opened in 3 days the date will be 3 days old. can I update tbDate on another control on my Main ...Unanswered | 3 Replies | 62 Views | Created by TurnipOrange - 22 hours 27 minutes ago | Last reply by Ken Sheridan - 4 hours 30 minutes ago -
1 Votes
Events Stop working after upgrades or updates to Microsoft Office
have a rather small database with only two tables, Four Forms, four queries and only one report. The tables however are 13,000 records and 7,000 ...Unanswered | 63 Replies | 487 Views | Created by VDSV - Friday, September 15, 2017 2:13 PM | Last reply by VDSV - 22 hours 10 minutes ago -
3 Votes
mouse scroll not working in access 2016 form view
We have access 2016 .accdb program running on Windows 8, From last week, suddenly on one computer, the Mouse scroll doesn't work in access 2016 form view, but Mouse scroll works in outlook, ...Unanswered | 7 Replies | 1543 Views | Created by Fangs3001 - Monday, August 21, 2017 8:39 AM | Last reply by Daniel Pineault - Friday, September 29, 2017 9:28 PM -
0 Votes
Forms built-in conditional formatting not recognizing populated field.
I have a user form that displays fields from a table as well as unbounded fields for the user to select and fill in. I've set the form fields default backcolor to be ...Answered | 3 Replies | 40 Views | Created by PSD1953 - Friday, September 29, 2017 1:21 PM | Last reply by .theDBguy - Friday, September 29, 2017 8:30 PM -
0 Votes
Forms and Subforms Multi-Key Links
Can this be done? I have two tables. One containing Customers, the other contains all the salesman for all customers. A one to many relationship. I have a third table that ...Answered | 3 Replies | 42 Views | Created by PSD1953 - Friday, September 29, 2017 2:18 PM | Last reply by .theDBguy - Friday, September 29, 2017 8:28 PM -
2 Votes
Too Few Parameters Error with Export to Text File Wizard
I am using MS ACCESS 2007 and am getting an error "too few parameters. 3 expected" when I try to use the Export Wizard to export a query result to a text file. From the research I have ...Answered | 3 Replies | 8315 Views | Created by lah12345 - Friday, May 27, 2011 5:17 PM | Last reply by sms2424 - Friday, September 29, 2017 5:53 PM -
0 Votes
Database opened with Windows 10 - Access 2016 won't work for users with Access 2013?
I have a database that is used by multiple users. I've recently used it with a new Windows 10/Office 2016 machine and now the other users on older Win2007/Office 2013 machines cannot use the ...Unanswered | 4 Replies | 136 Views | Created by JoshC2001 - Tuesday, September 19, 2017 6:07 PM | Last reply by JoshC2001 - Friday, September 29, 2017 2:55 PM -
0 Votes
Invalid procedure call or argument on getting field value
Hi I have a recordset field as below at the end. When I try to get value from rs.Fields(7).Value I get the 'Invalid procedure call or argument' error. What is the correct way ...Unanswered | 1 Replies | 49 Views | Created by Y a h y a - Thursday, September 28, 2017 10:57 PM | Last reply by Paul P Clement IV - Friday, September 29, 2017 1:58 PM -
0 Votes
Me.Variables in subroutine decalartions
I tried to use a form variable, e.g. Me.test to get a value by means of a subroutine call, like e.g. call ...Answered | 6 Replies | 60 Views | Created by Jan Lichtenbelt - Thursday, September 28, 2017 10:05 AM | Last reply by Imb-hb - Friday, September 29, 2017 12:58 PM -
0 Votes
To store Data in different tables by selecting a value in one combo box
I have created an access database for society maintenance funding. Now I want a combo box such that when I select a year as 2016 in combo box I want to store all the related fields from form ...Unanswered | 1 Replies | 29 Views | Created by krushan shah - Friday, September 29, 2017 7:06 AM | Last reply by Imb-hb - Friday, September 29, 2017 9:27 AM -
0 Votes
Access VBA to Delete fitered records from access table
Hi All, I want to delete filtered records where record no 1 is retained and rest are deleted. I am able to reach to the point where i am getting correct filtered records with record ...Unanswered | 1 Replies | 58 Views | Created by zaveri cc - Thursday, September 28, 2017 4:35 PM | Last reply by Ken Sheridan - Thursday, September 28, 2017 11:13 PM -
0 Votes
Unrecognized database format <filename>. (Error 3343)</filename>
I could potentially loose my business PLEASE I have all the data saved on ibook and I cant gain access to it I keep getting this message appear Unrecognized database format ...Unanswered | 2 Replies | 62 Views | Created by Natalie Moseley - Wednesday, September 27, 2017 8:00 PM | Last reply by QA Guy CommElec - Thursday, September 28, 2017 6:07 PM -
0 Votes
Mulitselect listboxes for a report
Can someone find where my code is wrong on this vba procedure ? ...Answered | 14 Replies | 150 Views | Created by kahlotus - Wednesday, September 27, 2017 9:41 PM | Last reply by kahlotus - Thursday, September 28, 2017 6:01 PM -
0 Votes
Access Query
Hi All, I have access table with 10 columns and nearly 40 K rows. I want to compare value in 1st 2 columns, and if values are same than delete duplicate row(s) which has lower value ...Proposed | 14 Replies | 90 Views | Created by zaveri cc - Wednesday, September 27, 2017 7:02 PM | Last reply by Ken Sheridan - Thursday, September 28, 2017 4:49 PM -
0 Votes
user server role
With Vba or with Api can I know the user server role? If the user is <SA> I am sure is an administrator, bat if the name is ...Answered | 4 Replies | 83 Views | Created by Marco Dell'Oca - Tuesday, September 26, 2017 11:11 AM | Last reply by .theDBguy - Thursday, September 28, 2017 3:29 PM -
3 Votes
Password validation
I am using the following code to secure access to my Access database: Private Sub cmdLogin_Click() Dim rstUsers As ...Unanswered | 12 Replies | 174 Views | Created by Gordon Swan - Saturday, September 23, 2017 8:35 PM | Last reply by .theDBguy - Thursday, September 28, 2017 2:50 PM -
1 Votes
Access 2016 Automatically Creates Copies Upon Exit
I have an access database that is sometimes used by me and sometimes by my analyst. The original file was called "Investments". Then it created a new copy (by itself) called ...Proposed | 2 Replies | 56 Views | Created by Sharon1839 - Monday, September 25, 2017 9:23 PM | Last reply by Edward Z - Thursday, September 28, 2017 9:03 AM -
0 Votes
fixed width file processing
Hi all, I have a database that exports data from a table to a text file using "TransferText" into a fixed width file. I need to open this file and ...Answered | 11 Replies | 106 Views | Created by Deon SA - Tuesday, September 26, 2017 8:15 AM | Last reply by Terry X - Thursday, September 28, 2017 7:58 AM - Items 1 to 20 of 24190 Next ›
No announcements
