Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.34 seconds.
Search: Posts Made By: arnelgp
Forum: Forms Yesterday, 11:45 PM
Replies: 13
Views: 120
Posted By arnelgp
Re: Conditional formatting by group

see form tlRegistration.
see how fncColorize is being called on the form's open event.
see the code and its limitation.
Forum: Forms 09-19-2018, 12:00 AM
Replies: 4
Views: 69
Posted By arnelgp
Re: how to show / hide duplicate button if a field is not null

use the Current Event of the Form:

Private Sub Form_Current()
Me.button.Visible = (IsNull(Me.Date_Input))
End Sub
Forum: General 09-18-2018, 08:15 AM
Replies: 18
Views: 338
Posted By arnelgp
Re: populate Count textbox based on drop-down list

you dont need to use the column if only names are on the list:

Private Sub Combo303_AfterUpdate()
Me.Txtempl = Nz(DCount("1", "tbl_empl", "employee_name='" & Me.Combo303 & "'"))

End Sub
Forum: Forms 09-18-2018, 04:14 AM
Replies: 5
Views: 91
Posted By arnelgp
Re: Combobox get value and filter another combobox

maybe something like this.
see the rowsource of the 2 combo.
view also the code on tbe sample form.
Forum: Queries 09-17-2018, 07:29 PM
Replies: 3
Views: 71
Posted By arnelgp
Re: Please help

copy and paste the sql to notepad. ctrl-h, replace Employee with tblEmployee. copy and paste back to access.
Forum: SQL Server 09-17-2018, 06:17 AM
Replies: 18
Views: 362
Posted By arnelgp
Re: Determine if SQL Server is online

I found this code in the net:

Public Function fncCheckMSSQL()
Const strComputer As String = "." 'Local Computer
Dim objWMIService As Variant
Dim colServices As Variant
Forum: Forms 09-17-2018, 06:07 AM
Replies: 7
Views: 111
Posted By arnelgp
Re: where's my form gone

i think you need to set the 'Has Module' property to Yes in order to see your form in the Microsoft Access Class Objects.
Forum: Forms 09-17-2018, 05:45 AM
Replies: 4
Views: 70
Posted By arnelgp
Re: Introducing a date filter to my search form

If Nz(Me.t6, "") <> "" Then
strFilter = strFilter & "[SelectedPeriod] >=#" & Format(Me.T6, "mm/dd/yyyy") & "# And "
End If

If Nz(Me.t7, "") <> "" Then
strFilter = strFilter & "[SelectedPeriod]...
Forum: Queries 09-16-2018, 11:42 PM
Replies: 16
Views: 215
Posted By arnelgp
Re: Combo Box parameter query

i change the parish field to numeric.
see sample form in the attached.
view the code of the combo afterupdate event.
Forum: Modules & VBA 09-16-2018, 07:49 PM
Replies: 2
Views: 97
Posted By arnelgp
Re: Header Titles from with in VBA

use the Caption property:

Me.Auto_Header0.Caption="Staff Data View - SDC Division (Edits Disabled)"
Forum: General 09-16-2018, 04:42 AM
Replies: 9
Views: 448
Posted By arnelgp
Re: Shared database with multi users

also you might need to go to advancd sharing on the control panel and set the password to none so that user will not see the ligin screen when they connext to the shared folder.
Forum: Queries 09-15-2018, 11:28 PM
Replies: 33
Views: 433
Posted By arnelgp
Re: Crosstab query with multiple value fields

here is your report.

i added another table, MealNameLocation.
the purpose of the above table is to
correctly sort/position the MealName and MealLocation
in order.

created two queries,...
Forum: General 09-15-2018, 08:35 PM
Replies: 9
Views: 448
Posted By arnelgp
Re: Shared database with multi users

also you have to allow all rights to the folders property.
Forum: Queries 09-14-2018, 11:27 PM
Replies: 19
Views: 280
Posted By arnelgp
Re: How to get rid of double records (SQL) - HELP!

suggest you do it first in excel, much simpler.
after coming to the final result, 1 record per partno+max date, then you can
create a link table in msa and use this link table instead of building a...
Forum: Queries 09-14-2018, 10:32 PM
Replies: 19
Views: 280
Posted By arnelgp
Re: How to get rid of double records (SQL) - HELP!

you know if the final step as you suggest in post #9 that the final is excel, you do not need to involve msa. just use excel. consolidate all sheets into one. select all columns. sort by partno and...
Forum: Queries 09-14-2018, 10:35 AM
Replies: 19
Views: 280
Posted By arnelgp
Re: How to get rid of double records (SQL) - HELP!

here is a pure SQL without the function:

SELECT T1.PartNo, T1.tDate As [Date],
(SELECT TOP 1 [Data1] FROM Orders AS T2 WHERE T2.PartNo=T1.PartNo And T2.[Date]=T1.tDate) As [Data1], ...
Forum: Queries 09-13-2018, 09:48 PM
Replies: 19
Views: 280
Posted By arnelgp
Re: How to get rid of double records (SQL) - HELP!

my previous post will not work.

i resort to using a user-define function.
copy and paste in a Standard Module.

note however that for this to work you
need to put a sorting order in the query...
Forum: General 09-13-2018, 07:29 PM
Replies: 6
Views: 510
Posted By arnelgp
Arrow Re: Help with saving prior search terms

maybe it would be more effective to use unbound combo with Value List as row source type than the textbox.
set the Limit to list property to yes and add code to not in a list event.
Forum: Modules & VBA 09-13-2018, 06:16 AM
Replies: 5
Views: 204
Posted By arnelgp
Re: Need HELP With Filtering Calendar

can you please try this.
Forum: Queries 09-12-2018, 12:03 PM
Replies: 32
Views: 375
Posted By arnelgp
Re: Splitting a text string into the numbers within

chk the 3 functions and query1.
Forum: Forms 09-12-2018, 12:00 AM
Replies: 9
Views: 142
Posted By arnelgp
Re: Disable close button of forms and application

this will Enable/Disable the Access Application Close (X) button.

Option Compare Database
Option Explicit
#If VBA7 Then

Private Declare PtrSafe Function GetSystemMenu Lib "user32" _
Forum: Forms 09-10-2018, 09:51 AM
Replies: 11
Views: 198
Posted By arnelgp
Re: Can't edit fields in form that uses calculated controls

you can edit the rest of the field but not the calculated.
Forum: Reports 09-09-2018, 09:02 AM
Replies: 5
Views: 184
Posted By arnelgp
Re: parameter as a title?

its easy as putting two unbound textbox to the report.

the Control Source is the Name of the parameter, eg:

for parameter 1
=[Start Date]

for parameter 2
=[End Date]
Forum: Reports 09-09-2018, 08:44 AM
Replies: 11
Views: 209
Posted By arnelgp
Re: Date Data Last Updated

or simply:

VBA..FileDateTime("FullPath of file")
Forum: General 09-08-2018, 09:30 AM
Replies: 8
Views: 927
Posted By arnelgp
Re: Msg from table

i modified the table and add another field. also modified gasman code.
you can put msg in greek if office is greek, english msg if not greek. the Locale ID for Greek is 1032. 1033 for EN(std).
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 07:11 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World