Go Back   Access World Forums > Search Forums

Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: Cronk
Forum: Tables Today, 08:52 AM
Replies: 5
Views: 116
Posted By Cronk
Re: Linking two backends together

And to go further, there could be many BEs, I guess limited to the maximum number of objects in an Access db. Though I can't conceive of any practical situation requiring hundred or more BEs. I had...
Forum: Tables Today, 08:38 AM
Replies: 15
Views: 310
Posted By Cronk
Re: Exporting tables to CSV - unparsable records

Re #10

That implies there is nothing wrong with any of the records in the table being exported and the problem is with the FE.

I suggest you create a new blank db and import everything from...
Forum: Modules & VBA 12-06-2019, 11:50 AM
Replies: 3
Views: 105
Posted By Cronk
Re: Working days - beginner

How do intend to select the range? Via a combo box, a text box or using query parameters?

Combos are best for providing a relatively small set of selections and forcing the user to select one....
Forum: Queries 12-01-2019, 09:38 PM
Replies: 8
Views: 292
Posted By Cronk

That would apply in a WHERE Clause but not in a SELECT field string.
Forum: Modules & VBA 11-29-2019, 10:34 AM
Replies: 7
Views: 138
Posted By Cronk
Re: HTML table using excel data

Immediate window
? "A" & 5

? "A" & date()
Try it.
Forum: Tables 11-29-2019, 10:22 AM
Replies: 12
Views: 336
Posted By Cronk
Re: Looking for some advice about structure and importing data

First thing is to import your data into a table in your database. Set the Data Type for all of the fields Short Text in that import table. I've found that often there will be data issues where say...
Forum: Modules & VBA 11-27-2019, 09:46 AM
Replies: 4
Views: 146
Posted By Cronk
Re: parsing quotation literals in code

Another alternative is chr(34) which handles data with single quote included.

....."WHERE [field] = " & chr(34) & me.StringControl & chr(34)
Forum: Tables 11-27-2019, 09:40 AM
Replies: 20
Views: 217
Posted By Cronk
Re: Two Foreign Keys???

Better to use an Autonumber key field and if you want to store the Sales Order No as text,use a separate field

SalesOrderID Autonumber
SalesOrderNo Short text
CustomerID ...
Forum: Modules & VBA 11-24-2019, 10:51 AM
Replies: 12
Views: 313
Posted By Cronk
Re: Array - testing neighboring elements

In the OP

I suspect that the operation might be significantly faster if the individual words were extracted into an indexed table with an autonumber index and another field to indicate...
Forum: General 11-22-2019, 11:16 AM
Replies: 7
Views: 184
Posted By Cronk
Re: Weird Problem (to me anyway)

Yes, corruption of table indicies could cause the behaviour observed and a Compact&Repair would fix that.

Always keep backup copies though.

And for major problems, I prefer to import,...
Forum: Modules & VBA 11-14-2019, 03:06 PM
Replies: 18
Views: 299
Posted By Cronk
Re: VBA Help

Then again, what guarantee is there that the form will be signed on the first visit.?
... on or after 18th birthday.

I had in mind a yes/no field in the patient table (or maybe a...
Forum: General 11-14-2019, 10:20 AM
Replies: 35
Views: 323
Posted By Cronk
Re: A Question of Trust

Trusted locations is a MS Office security thing, not Access per se. Same thing happens with macros in Excel files.

Any folder (and optionally sub folder) can be designated as a Trusted...
Forum: Modules & VBA 11-14-2019, 09:53 AM
Replies: 18
Views: 299
Posted By Cronk
Re: VBA Help

I now believe the OP wants to have the message pop up only once and with 3 visits in a year, the message could pop 3 times depending on when the birthday occurs in the year.

We don't...
Forum: Modules & VBA 11-13-2019, 08:21 PM
Replies: 18
Views: 299
Posted By Cronk
Re: VBA Help

In your report in the Detail (or wherever you have the text boxes", in the format event, have the following code

private sub detail_format(cancel as integer, formatcount as integer)

Forum: Modules & VBA 11-13-2019, 11:42 AM
Replies: 18
Views: 299
Posted By Cronk
Re: VBA Help

The OP was

It's unlikely that the visit will be on the actual birthday date.

I think the question should be, for a visit date, is the person 18 or more and has the form been signed.
Forum: Modules & VBA 11-07-2019, 11:31 AM
Replies: 10
Views: 144
Posted By Cronk
Re: Problem with critera on report

If the above responses don't solve the issue, insert the following line above the docmd.openreportdebug.print "[T_age] Between '" & Nz(Me.Text74, 0) & "' And '" & Nz(Me.Text57, 0) & "' and ...
Forum: Modules & VBA 11-07-2019, 11:09 AM
Replies: 47
Views: 881
Posted By Cronk
Re: can't figure where I'm going wrong

Nobody suggested what I'd consider to be the simplest solution
Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets WHERE Year([DateOpened])=" & me.CmbYear )
Forum: General 11-06-2019, 09:36 PM
Replies: 15
Views: 315
Posted By Cronk
Re: Link to a powerpoint slide from an Access form

You could try something like
strFile =dLookup("FileName", "tblQuiz", "Quiz=" & cboSelectQuiz)
strSlideNo = inputbox "What is selected slide to start" &
Shell "C:\Program Files\Microsoft...
Forum: General 11-03-2019, 09:50 PM
Replies: 3
Views: 167
Posted By Cronk
Re: Python exercise

This site is for Microsoft Access. The programming language is VBA. I suggest you look for another site to direct your questions.
Forum: Modules & VBA 11-03-2019, 08:05 PM
Replies: 14
Views: 289
Posted By Cronk
Re: Changing Record Source

Use the recordsource property and OpenArgs
docmd.openform "FacilityEquipmentNotes",,,,,,"dbo_FacilityEquipmentNotes"

In the form's open event
me.recordsource = "select * from " & me.openargs
Forum: Modules & VBA 10-31-2019, 04:18 PM
Replies: 19
Views: 384
Posted By Cronk
Re: If Then Statement: Compile Error, Expected: =

I think what the OP wants is
If Me.cboOption.Column(0) = "1" Or Me.cboOption.Column(0) = "2" Then
if Nz(Me.Example1, 0) < Nz(Me.Example2, 0) then
Cancel = True
MsgBox "You number...
Forum: General 10-28-2019, 10:12 PM
Replies: 14
Views: 299
Posted By Cronk
Re: Error "The record source '|' specified on this form or report does not exist"

What the connections that you referred to in #6? I don't see how you have connections with an unsplit database.
Forum: General 10-28-2019, 03:28 PM
Replies: 14
Views: 299
Posted By Cronk
Re: Error "The record source '|' specified on this form or report does not exist"

Or the linked tables are to data that is not available to the problem PC.

Or the backend is meant to reside with the front end on the local disk ie read only system and the backend is not being...
Forum: General 10-28-2019, 01:24 PM
Replies: 14
Views: 299
Posted By Cronk
Re: Error "The record source '|' specified on this form or report does not exist"

It's still confusing. Tables exist inside a database. Is the database file not being sent? Or are the linked tables data inside a spreadsheet/s?
Forum: General 10-23-2019, 08:13 PM
Replies: 12
Views: 173
Posted By Cronk
Re: hyperlink query

I don't think you can export data from a query to Excel and have it displayed as a hyperlink.

I have done it by automation

wsSheet.hyperlinks.add anchor:=application.selection, address:= ...
Showing results 1 to 25 of 500

Forum Jump

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

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