Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: JANR
Forum: Forms 11-30-2017, 02:41 AM
Replies: 36
Views: 1,184
Posted By JANR
Re: calculated fields cant see in the database

You're window's setting for decimal seperator is most likely a comma and not a period, just replace .75 with 0,75

Quota_Totale: ([TotaleAdulti]+[TotaleRagazzi]+[TataleBambini])*0,75

Forum: Modules & VBA 05-19-2017, 03:08 AM
Replies: 5
Views: 638
Posted By JANR
Re: Run time error '13': Type Mismatch

list over Excel constants: https://msdn.microsoft.com/en-us/library/aa221100(office.11).aspx

Forum: Queries 04-26-2017, 02:30 AM
Replies: 10
Views: 783
Posted By JANR
Re: Changing all ZLS in a table to Null

Set the property "AllowZeroLength" of the field(s) in your table to No.

To do it to all your tables se this: http://allenbrowne.com/bug-09.html

good luck

Jan R
Forum: Queries 04-20-2017, 05:52 AM
Replies: 7
Views: 444
Posted By JANR
Re: Help with Access IF Statement

This is better suited for the Switch() function.


DisplayText: Switch([Age-CRD]<=5,"0-5",[Age-CRD]<=10,"6-10", .... ,[Age-CRD]>365,0)

Good luck

Jan R
Forum: Forms 02-16-2017, 07:29 AM
Replies: 11
Views: 1,629
Posted By JANR
Re: How to prevent (lock) the deletion of a column in a subform in Datasheet view?

In Access 2010 accdb I can delete a Column/Field even in form view by right clicking the column and choose delete, or simply press the delete button. I suspect this for the developer to quickly...
Forum: Modules & VBA 10-03-2016, 03:07 AM
Replies: 22
Views: 791
Posted By JANR
Re: Updating a local table from a linked table workaround

Enclose amazon-order-id in square brackets

like so: [amazon-order-id]

Forum: Modules & VBA 09-06-2016, 10:01 PM
Replies: 12
Views: 892
Posted By JANR
Re: XIRR for non-periodic dates and flows by investment

SelectSql = "SELECT CFlow, TDate FROM XIRR_Array WHERE [Match Code]= 'MatchCode' ORDER BY TDate"

This select statement is looking for records in your table XIRR_ARRAY where the field Match Code is...
Forum: Modules & VBA 05-02-2016, 09:48 PM
Replies: 14
Views: 862
Posted By JANR
Re: Access VBA code to open & sort excel sheet

With oBook.Sheets(1).Range("C2", oBook.Sheets(1).Range("C" & oBook.Sheets(1).Rows.Count).End(xlUp))

If you are going to use late binding, you have to tell Access what the value of xlUp is. This is...
Forum: Modules & VBA 04-12-2016, 05:37 AM
Replies: 10
Views: 543
Posted By JANR
Re: Save a Table as text Instructions

Here is a start: http://allenbrowne.com/func-06.html

Jan R
Forum: Excel 03-23-2016, 05:11 AM
Replies: 3
Views: 1,257
Posted By JANR
Re: Combine Date and Time column

You don't concaenate date and time, you ADD them together, to get date and time


Forum: Modules & VBA 03-11-2016, 10:11 AM
Replies: 14
Views: 3,281
Posted By JANR
Re: When is the "OpenDatabase" Method Needed?

This methode is for ADO right Galaxiom? since DAO do not have a .State property as far as I know.

But I can however perhaps do something like this to be sure that recordsets as closed after I'm...
Forum: Modules & VBA 03-10-2016, 11:14 PM
Replies: 14
Views: 3,281
Posted By JANR
Re: When is the "OpenDatabase" Method Needed?

But what if you get an error within your with-block?

On Error Goto Handler

With CurrentDb.OpenRecordset(SQL)
Do While Not .EOF
Forum: Modules & VBA 01-18-2016, 03:51 AM
Replies: 9
Views: 22,221
Posted By JANR
Re: Append record if exist or Update if not exist

Access do not support a full outer join. Change til to either Right Join or Left Join.

In your case I think you need Left Join

Also use your real table names marked in blue

Forum: Forms 11-19-2015, 05:48 AM
Replies: 2
Views: 259
Posted By JANR
Re: Locking a Form once data has been entered

Avoid the problem by issuing your sequence number only for new records.


If Me.NewRecord then
Me.Seqence = Nz(Dmax(.....),0) + 1
End If

Jan R
Forum: Queries 11-11-2015, 07:50 AM
Replies: 11
Views: 603
Posted By JANR
Re: removing zeros


Why go to all that trouble, Format()-function already turns the date into a string.

Forum: Queries 11-11-2015, 07:30 AM
Replies: 11
Views: 603
Posted By JANR
Re: removing zeros

Have you tried the Format() function?


depended on which "number" is day and which "number" is month

Forum: Queries 11-11-2015, 07:00 AM
Replies: 2
Views: 410
Posted By JANR
Re: Can't get to SQL view

You can type this in the immediate window


and hit the enter button and your sql will print out, do yor corrections and paste it into a query

Forum: Modules & VBA 10-26-2015, 04:04 AM
Replies: 5
Views: 683
Posted By JANR
Re: Vba Insert into tbl

DoCmd.RunSQL "INSERT INTO JobsStaffAvail ( tblJobsID, tblStaffAvailID, bookedBy )" _
& "VALUES(Forms!frmbookstafftojob.JobsID ,Forms!frmbookstafftojob.subfrmStaffAvail.Form.staffid , BookedBy)"...
Forum: Modules & VBA 10-06-2015, 10:03 PM
Replies: 11
Views: 837
Posted By JANR
Re: Escaping # chr(35) in an sql

A shot in the dark. Your fieldname "Desc" in your insert statment is a SQL reserved word. Put square brackets around it.

Const sqlM = "INSERT INTO tempImplantManagement " & _
Forum: Modules & VBA 05-08-2015, 11:29 PM
Replies: 7
Views: 922
Posted By JANR
Re: Type Mismatch Error

Wrap DLookup using the NZ() function to handle nulls.


If Nz(DLookup(.......),"") = "" Then ... I would just open a recordset and test if there are any records, if so you open Form1

Forum: Modules & VBA 05-08-2015, 11:09 PM
Replies: 8
Views: 2,142
Posted By JANR
Re: OpenRecordset and ODBC linked tables

Here is an example on what Galaxiom is trying tell you


Dim blnConnected As Boolean
Dim dbConnection As DAO.Recordset

Sub MainLink()
'Loop ODBCTables
...your loopcode goes...
Forum: Forms 05-07-2015, 09:18 PM
Replies: 11
Views: 4,492
Posted By JANR
Smile Re: Continuous form - current vs selected record on cmd click

No a commandbutton when it's clicked moves the focus to that record and makes it the current record so you can refrence the correct record in your code. By making it transparent your users will think...
Forum: Forms 05-07-2015, 11:18 AM
Replies: 11
Views: 4,492
Posted By JANR
Re: Continuous form - current vs selected record on cmd click

Why don't you create 3 commandbuttons and place these over your images, and use the commandbuttons Click_Event to execute your code.

Just set the commandbuttons backstyle property to...
Forum: Modules & VBA 05-07-2015, 05:53 AM
Replies: 5
Views: 489
Posted By JANR
Re: Mutliplication with str function

FYI the order of mathematical operations is different for a computer than a human.

For a human this:

2+2*4 = 16

A computer will look at the same expression and conclude that the answer is...
Forum: Queries 03-25-2015, 08:22 AM
Replies: 4
Views: 425
Posted By JANR
Re: Formula paste error

This should get you started.

Function Phases(CurPhase As Variant, NumOfDays As Integer) As String
Select Case CurPhase
Case "Phase 1", "Phase 3a", "Phase 5", "Phase 6"
Showing results 1 to 25 of 500

Forum Jump

All times are GMT -8. The time now is 04:33 AM.

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

Featured Forum post

Sponsored Links

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