Search results

Friends, Please, help me with this... I have two files: main.xls and main.mdb. main.xls has one single sheet (SheetData) main.mdb has one table called (tblData) I have to LINK main.xls (SheetData) to main.mdb (tblData). To do this, I have a form with a button (bttLinkFile). Private Sub...

Friends, Please, tell me if it's possible and how to do it. - I have 1 table (tblProducts). - I have 3 queries based on that table (qryProd1, qryProd2, qryProd3). - Those 3 queries have the same structure, they are identical, but each one has different criteria for filtering records from...

Friends, Please, how can I create a VBA code which counts the number of records loaded in a form? In a form (TextBox), I can use ... Count(*) ... but when it comes to VBA code, this doesn't work. I also cannot use ... DCount("*", "Table") ... because this form is opened from a button in...

Friends, Hi, everyone. Please, anybody can help me with these?... ----- 1) How to show the value of a variable inside a TextBox, in a form or report? I know how to show it in a MsgBox, but I want it to be shown in a TextBox, merged with some other texts of mine. Example: "It's been " &...

Friends, Please, I really need some help, here because I don't understand what's happening. :( I have a form which is opened based on these parameters, after a user logs in: **** Code ***** Private Sub Form_Open(Cancel As Integer) On Error GoTo Err_Form_Open Select Case IntCodePerm...

Friends, I'm using a VB code to open a form with permissions (as a good friend has taught me how to do). Here it is... (... more code above) Me.Form.AllowAdditions = True Me.Form.AllowDeletions = True Me.Form.AllowEdits = False (... more code below) When the form is opened this...

Dear friends, Please, I want to use AllowAdditions, AllowDeletions and AllowEdits for a form of mine, but I just don't know how to create a VB code to do it. Here's my case... I have a form which is opened only before a password confirmation. I'm gonna call it "MainForm". And the form I...

Friends, Please, anybody knows if there's any way to configure permissions (add, edit, delete records) without using MS Access default Group/Users Security Accounts? Because of particular reasons, I've created a self login system for a DB of mine, I mean, it has a table with names, passwords...

Friends, Please, I just created an expression here and it's not working out. I have a report with a field called ItemPrice. This report is linked to a query. I created a TextBox to sum all the prices shown in the report. Here it is... =Sum([ItemPrice]) It's in the report footer. It...

Friends, Is there any way to show an unique field in more than one COLUMN, in a report? I explain... Report example: ---------- Page 1 ---------- REPORT HEADER Field title 1st record shown 2nd record shown 3th record shown 4th record shown 5th record shown 6th record shown 7th record shown...

Hello, friends. I'd like to store a value I typed in an InputBox inside a field, in a form (something like default value). Is this possible? That's the deal... I have a form and it has 2 fields: Date and Name (with a dropdown). I have names of people who were present in an assembly. When I...

Friends, Another doubt of mine. (Sorry, but I'm a real begginer.) :o I want to calculate the age of a client, but you know it's not simply to do this: =Date()-[DateOfBirth] & "years old" For, depending on his date of birth and today's date, the calculation should be: =Date()-[DateOfBirth]-1...

Hi, friends. I'm trying to count records in a report, using a filter but I'm not doing well with it... In my report there are these fields: - Car_Plate - Car_Model - Car_Color Etc. The report shows all the cars. But at the bottom, I want to count specific ones. For example: Number of cars...

Fellas, Please, can anybody tell me how to create an expression, inside a textbox in a report, to count the number of records in a query? Detail: This query has no link to the report. I don't wanna use VB. But, if there's no other way, how could I do that using VB and showin the result in a...

Friends, I have a little problem here and I just don't know how to solve it. :( I've got 3 tables: Table1: CLIENTS Field1: Client_Code (Autonum) Field2: Client_Name Etc. Table2: CARS Field1: Car_Code (Autonum) Field2: Car_Plate Etc. Table3: RENTAL Field1: Rental_Code (Autonum) Field2...

VLookUp (Excel): What is the same function for Access? Hello, Fellas. Please, anybody knows how I can use VLookUp (Excel) in Access? I mean, is there any function for Access which works the same as VLookUp for Excel? I have this form and there's a field in it which contains a dropdown. When I...