Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 5.15 seconds.
Search: Posts Made By: spikepl
Forum: Modules & VBA 11-05-2015, 01:58 PM
Replies: 7
Views: 794
Posted By spikepl
Forum: The Watercooler 11-05-2015, 12:43 PM
Replies: 24
Views: 2,386
Posted By spikepl
Re: And Now For Something Completely Different - What Cartoons / Shows do we share?

For people dealing with projects and software, apart from the the obligatory Dilbert stuff, I can highly recommend Geek & Poke http://geek-and-poke.com/ . Some of them are absolutely hilarious, some...
Forum: General 11-05-2015, 11:47 AM
Replies: 3
Views: 822
Posted By spikepl
Re: MS Access macro that generates an Excel file from a template

SO what is unclear in the posts you searched and found about how to get data from Access to Excel?
Forum: Macros 11-05-2015, 11:42 AM
Replies: 12
Views: 1,269
Posted By spikepl
Re: Macro - After event create multiple records

I need an example of data because I still suspect some things. 2-3 students, each with different requirements and accomplishments. Just enough to get the gist of how this thing is supposed to work...
Forum: Macros 11-05-2015, 11:03 AM
Replies: 12
Views: 1,269
Posted By spikepl
Re: Macro - After event create multiple records

I need more than just a title. Give an example please. Again, the seemingly envisaged structure does not seem the proper one.
Forum: Macros 11-05-2015, 10:57 AM
Replies: 12
Views: 1,269
Posted By spikepl
Re: Macro - After event create multiple records

You might want to backup a bit and not getting lost in the finer Access details explain what this is about.

Because I smell something very very fishy here. To assign qualifications/passes your...
Forum: General 11-05-2015, 09:11 AM
Replies: 4
Views: 966
Posted By spikepl
Re: Output Form to HTML - change CELLSPACING

No idea how to manipulate the template, whatever there might be of one. You could always reopen the produced HTML file afterwards as pure text, and line by line replace all CELLSPACING=0 with...
Forum: Forms 11-05-2015, 08:47 AM
Replies: 11
Views: 2,871
Posted By spikepl
Re: You may be at the end of a recordset | Error 2105

I have up/down , but should be the same as next/previous, play with it, call it from Current event handler:

Public Sub SetMoveButtons(MyForm As Form)

With MyForm

If Not...
Forum: Forms 11-05-2015, 07:54 AM
Replies: 12
Views: 584
Posted By spikepl
Re: Displaying a PDF document link in a form

Read the documentation for the FollowHyperlink method
Forum: General 11-05-2015, 07:18 AM
Replies: 13
Views: 916
Posted By spikepl
Re: Beginner - General design

I've personally witnessed over a period of 1 years how stagiaires and their work were treated in a French high-tech company. Worse than the disposable Mexicans in one of the maquilladoras on the US...
Forum: Forms 11-05-2015, 07:08 AM
Replies: 12
Views: 584
Posted By spikepl
Re: Displaying a PDF document link in a form

look up FollowHyperlink method
Forum: Queries 11-05-2015, 07:07 AM
Replies: 3
Views: 908
Posted By spikepl
Re: loop of DELETE sql on one record - occasional error 3086

So our magic eyesight can see all the code you're running and identifies line 42 as the likely culprit.


If you want a better bet, you might consider providing something solid to look at.
Forum: Reports 11-04-2015, 02:18 PM
Replies: 9
Views: 893
Posted By spikepl
Re: Cannot Open Attachments In Pdf Created From Access

This is really a poor and ambiguous formulation. Say what you do and what happens in response to that, never use the totally informationless "I cannot", because that contains no useful information...
Forum: Tables 11-04-2015, 02:15 PM
Replies: 1
Views: 727
Posted By spikepl
Re: Tables and Combo Boxes

These operations you do in a form. No access to tables for users. You have cascading comboboxes (search) and the Not In LIst event for a combo, to insert new stuff. Look in the manual.
Forum: Queries 11-04-2015, 02:11 PM
Replies: 4
Views: 478
Posted By spikepl
Re: case-sensitive

"don't look the same " where exactly. Supply the context in which you wish to discern
Forum: Tables 11-04-2015, 11:58 AM
Replies: 6
Views: 818
Posted By spikepl
Re: Ive Got the Many-to-Many Blues

You have not supplied any specific information as to

1. which table is to be linked to which table
2. by which key or keys
3. by what type of relation

Show the tables produced by this...
Forum: General 11-04-2015, 07:53 AM
Replies: 4
Views: 605
Posted By spikepl
Re: Calculate Column in Listbox based on User Date

Calculating values in tables based on stuff outside of the tables makes no sense, since the values are no longer fixed. Do that in a query, base your listbox on that query. In a query you can...
Forum: General 11-04-2015, 02:39 AM
Replies: 13
Views: 916
Posted By spikepl
Re: Beginner - General design

Maybe our reading of the situation is entirely wrong. But if you are "just" a stagiaire, then you could feign total ignorance of, and show total disregard for, such issues and just get cracking.
...
Forum: General 11-03-2015, 02:24 PM
Replies: 10
Views: 869
Posted By spikepl
Re: Escaping special characters when entering values in DataSheet view

Try "" for each ". So """" in total. Meaning, in VBA.

In typing in plain bound textbox "" should do.
Forum: General 11-03-2015, 01:06 PM
Replies: 4
Views: 1,754
Posted By spikepl
Re: "SendObject Isn't Available Now" with v2013 MS applications

This user is one here who has written the most about the newest Office offerings. You might try to PM him: http://www.access-programmers.co.uk/forums/member.php?u=31847
Forum: Modules & VBA 11-03-2015, 12:31 PM
Replies: 16
Views: 888
Posted By spikepl
Re: Creating userlevel access type mismatch error

Well go on then , solve it yourself.
Forum: Modules & VBA 11-03-2015, 12:26 PM
Replies: 16
Views: 888
Posted By spikepl
Re: Creating userlevel access type mismatch error

Provide the actual code used, not stories. Not much help can be provided if you just submit stories. Read my signature.
Forum: Queries 11-03-2015, 12:23 PM
Replies: 31
Views: 2,923
Posted By spikepl
Re: Query off of a SQL Server

It is not a question of "why" right now but "what". What gets across from Access to SQL correctly and what doesn't. You have plenty of stuff to try - strings, or perhaps strings after a date, or...
Forum: Queries 11-03-2015, 10:41 AM
Replies: 31
Views: 2,923
Posted By spikepl
Re: Query off of a SQL Server

OH. I thought only 30200 did not return but the others did. Again, check contents of the field in SQL and the contents of the criteria character by character, would be my advice.
Forum: Queries 11-03-2015, 10:34 AM
Replies: 31
Views: 2,923
Posted By spikepl
Re: Query off of a SQL Server

Perhaps that particular code in the data is not 30200 but 3O2OO or something like that. Check all characters.
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:15 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
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