Access World Forums > Search Forums Search Results

User Name Remember Me? Password

Page 1 of 20 1 2 3 11 > Last »

Showing results 1 to 25 of 500 Search took 0.17 seconds. Search: Posts Made By: arnelgp

Forum: Modules & VBA 11-20-2019, 01:40 AM

Replies: 2 criteria to sum same product for one person Views: 111 Posted By arnelgp Re: criteria to sum same product for one person create a user-defined function and pass the PID number to check with the function: Public Function fnCountProduct(pid As Long) Dim rs As DAO.Recordset Dim db As DAO.Database Dim...

Forum: Modules & VBA 10-30-2019, 03:24 AM

Replies: 7 Use input to determine which field to choose in SQL-WHERE Views: 177 Posted By arnelgp Re: Use input to determine which field to choose in SQL-WHERE since you already has VBA, then substitute the fieldname using VBA: dim strSQL As String dim qd As DAO.Querydef strSQL = select * from table where p% like '*" & [Name ?] & "*'" select...

Forum: Forms 10-30-2019, 03:13 AM

Replies: 10 Duplicate Form with Subform Views: 197 Posted By arnelgp Re: Duplicate Form with Subform duplicate with subform

Forum: Forms 10-30-2019, 12:01 AM

Replies: 9 How to catch keyreturn in Listview Views: 192 Posted By arnelgp Re: How to catch keyreturn in Listview maybe use Keypress event.

Forum: Forms 10-29-2019, 01:30 AM

Replies: 8 Re: Reports displaying multiple records Views: 207 Posted By arnelgp Re: Reports displaying multiple records fix the report.

Forum: Reports 10-28-2019, 05:26 AM

Replies: 4 Count but not the repeated ones Views: 143 Posted By arnelgp Re: Count but not the repeated ones this will work on Print Preview only: Dim dict As Object dim lngCount As Long Private Sub Report_Open(Cancel As Integer) Set dict = CreateObject("scripting.dictionary") End Sub ...

Forum: Modules & VBA 10-28-2019, 05:03 AM

Replies: 33 [SOLVED] Custom ribbon images Views: 452 Posted By arnelgp Re: Custom ribbon images you're image files should already have transparent background (png) for it to work.

Forum: Queries 10-27-2019, 11:15 PM

Replies: 2 Dlookup into a query field using Date Criteria Views: 115 Posted By arnelgp Re: Dlookup into a query field using Date Criteria DLookUp("EXCRate","ExchangeRates","EXCDate=#" & Format([DateEntered], 'mm\/dd\/yyyy') & "#")

Forum: Forms 10-27-2019, 09:55 AM

Replies: 11 Update the value in a field based upon Views: 160 Posted By arnelgp Re: Update the value in a field based upon the update will not be immediate, you need to go to another record to reflect the change. if you want immediate change, add this Expression on the Change Event of each 9 checkbox: =fncACLMet() ...

Forum: Forms 10-27-2019, 09:36 AM

Replies: 11 Update the value in a field based upon Views: 160 Posted By arnelgp Re: Update the value in a field based upon it won't update the field because of the expression on the textbox: =IIf(Abs(([ACL1]+[ACL2]+[ACL3]+[ACL4]+[ACL5]+[ACL6]+[ACL7]+[ACL8]+[ACL9]))>5,[ACL - Met]=Yes,[ACL - Met]=No) remove the...

Forum: Forms 10-27-2019, 09:26 AM

Replies: 8 Re: Reports displaying multiple records Views: 207 Posted By arnelgp Re: Reports displaying multiple records no worries, i get that all the time. check the code, its very simple.

Forum: Modules & VBA 10-27-2019, 03:43 AM

Replies: 21 Use vba Indexes Views: 358 Posted By arnelgp Re: Use vba Indexes add space between "&" MkDir (strPathNl) & newNameA & "\" & newNameA & i

Forum: Modules & VBA 10-27-2019, 02:01 AM

Replies: 21 Use vba Indexes Views: 358 Posted By arnelgp Re: Use vba Indexes is this correct? strPathNl = toPath & "" & rst!NomName & "" '. Pieces officielles"

Forum: General 10-27-2019, 01:09 AM

Replies: 9 access 2016 datasheet change column order left-to-right Views: 155 Posted By arnelgp Re: access 2016 datasheet change column order left-to-right do you have Arabic office?

Forum: Modules & VBA 10-26-2019, 10:59 PM

Replies: 7 Filter Datasheet Split Form Views: 194 Posted By arnelgp Re: Filter Datasheet Split Form Private Sub Form_Load() On Error Resume Next Dim Department As Integer '''''' Department Privilege ''''''' Department = Val(DLookup("Department", "Employees", "[UserLogin] = '"...

Forum: Modules & VBA 10-26-2019, 10:46 PM

Replies: 8 Date to Date Views: 168 Posted By arnelgp Re: Date to Date format(fieldName, "short date") or format(fieldName, "mm/dd/yyyy") or CDate(fieldname)

Forum: Modules & VBA 10-26-2019, 06:40 PM

Replies: 3 Where Condition with multiple value Views: 152 Posted By arnelgp Re: Where Condition with multiple value SQLDataSource = " SELECT * FROM tbtaskschedule WHERE TaskAssignedTo = " & TempVars![SYSID] & " And TaskBenefitID = " & forms!frbillingtest!benefitsid

Forum: General 10-26-2019, 11:42 AM

Replies: 21 Need "Select All Option" in Combobox for Query Parameters Views: 439 Posted By arnelgp Re: Need "Select All Option" in Combobox for Query Parameters can still be simplified: SELECT [Employee Expenses].[Entry Number], [Employee Expenses].[Account Name], [Employee Expenses].[Employee Name], [Employee Expenses].[Work Date], [Employee...

Forum: Forms 10-26-2019, 10:07 AM

Replies: 8 Re: Reports displaying multiple records Views: 207 Posted By arnelgp Re: Reports displaying multiple records check and test. some trips don't have fuel records.

Forum: General 10-26-2019, 09:20 AM

Replies: 21 Need "Select All Option" in Combobox for Query Parameters Views: 439 Posted By arnelgp Re: Need "Select All Option" in Combobox for Query Parameters what is the Combo name and the Bound Column number?

Forum: Forms 10-26-2019, 08:02 AM

Replies: 6 Button click to open a list of forms Views: 129 Posted By arnelgp Re: Button click to open a list of forms there is no need to create separate form for each month. just use one form for all months and just filter the form for the month to display.

Forum: General 10-26-2019, 08:01 AM

Replies: 21 Need "Select All Option" in Combobox for Query Parameters Views: 439 Posted By arnelgp Re: Need "Select All Option" in Combobox for Query Parameters SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] WHERE [ID] = IIF(Trim([FORMS]!yourFormName!comboName & "")="", [ID],...

Forum: Forms 10-26-2019, 06:52 AM

Replies: 8 [SOLVED] Get value from record by clicking on it ?? Views: 165 Posted By arnelgp Re: Get value from record by clicking on it ?? how do you add participants? through subform? you can use the subforms recordsource and select participants Not in subform. or you can use an Insert Query to select participants Not in the...

Forum: General 10-26-2019, 12:11 AM

Replies: 21 Need "Select All Option" in Combobox for Query Parameters Views: 439 Posted By arnelgp Re: Need "Select All Option" in Combobox for Query Parameters SELECT [Employee Directory].[ID], [Employee Directory].[Employee Name] FROM [Employee Directory] WHERE [Employee Directory].[Employee Name] = IIF([FORMS]![yourForm]![yourCombo] = "Select All",...

Forum: General 10-26-2019, 12:05 AM

Replies: 4 Form Operations Misc Views: 145 Posted By arnelgp Re: Form Operations Misc here you may test.

Showing results 1 to 25 of 500

Page 1 of 20 1 2 3 11 > Last »

Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Access World     Access World News     Site Suggestions     Introduce Yourself     The Watercooler Microsoft Access Discussion     General     Tables     Queries     Forms     Reports     Macros     Modules & VBA     Theory and practice of database design     Access Web Microsoft Access Reference     Access FAQs     Code Repository     Sample Databases     Microsoft Access Tutorials     Microsoft Access User Groups Apps and Windows     SQL Server     Crystal Reports     Visual Basic     VB.NET     Word     Excel     Web Design and Development         ASP and ASP.NET         PHP & MySQL     Windows     Other Software     Hardware Questions and Answers Non-Access Issues     Politics & Current Events     Debates     Gaming     Sports, Health & Fitness     Gadgets     Small Business