Search results

I need some help, please. So, I have a database that I've split and have deployed to 7 persons. The thing is, I have three (3) forms: Form 1 Form 2 Form 3 ...that require changing a portion of a line in each form's respective VBA codes. I need to change the directories to where an excel...

This is a query, report and vba question. I'm using Ms Access 2007. TABLE 1: projectname, activityname, totalhoursworked, employeename TABLE 2: employeename, employeelevel TABLE 3: employeelevel, rate I created a select query to join the info that I need. SELECT QUERY 1: projectname...

I want a query that gives me something like this from 2 different tables: table1 - AA, AC, DE table2 - AA01, AA02, AA03, AC01, DE01, DE02 query - column 1 - column 2 AA - AA01 ------ AA02 ------ AA03 AC - AC01 DE - DE01...

Hey guys, I need some assistance, please. I'm not that good with VBA, but I was reading some other threads re my problem, but I was a bit confused. they are old threads, I need someone to converse with. I'm using Access 2007. I have a few problems and I want them to be able to be done from...

Hey guys, I need some assistance, please. I'm using Access 2007. I have a few problems: 1. I have a switchboard. I want to click a button, that opens a form with a dropdown list, when I make my selection, it opens a subform in add mode, but the linked field in the subform isn't empty, but...

Hello I am using Access 2007. Mainform name: Visitors Fields: Visitor ID, Company ID, Last Name, First Name, Gender, Telephone No, Next of Kin, Package (This is a combo box with 2 columns and 5 rows), Status (This is a combo box with 1 column and 2 rows), Reservation Date, Duration of Stay...

I have a table, namely Burnt DVDs (Movies/TV Series). It has 3 fields of data, namely Title, Release Date and Comment(which has the data type, Memo). I also have a form, namely Burnt DVDs (Movies/TV Series) Search Who Loaned DVD that is linked to a select query. The query filters the records...

I'm new to vba coding and I would like some assistance please. I want whenever I'm updating or adding records to my form, the ID automatically take the value of the previous ID and increment it by 1. The field type is text (mixed with number) - PM0000000. I've done some research, what I...

Hello! My name is Hutchy and I'm from Jamaica. I'm an average user of Microsoft Access and I'm new to VB.