Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.06 seconds.
Search: Posts Made By: static
Forum: Modules & VBA 02-07-2018, 02:17 AM
Replies: 18
Views: 446
Posted By static
Re: Show/hide columns with specific text

You can use a query to add some normalisation to begin with.

select projectnr,machine,[hour meter,[date / time], ucrollers as chk, 'rollers' as chktype from tblchecklist
union
select...
Forum: Tables 01-26-2018, 03:48 PM
Replies: 17
Views: 564
Posted By static
Re: table not populating

The recordset is updateable otherwise the form would be locked. So something is being updated.

Perhaps a record other than the expected record is being updated? Check Master Child fields of the...
Forum: Modules & VBA 01-26-2018, 02:16 PM
Replies: 11
Views: 365
Posted By static
Re: How to check for running instance of access database and then update

My take was that he's running this from Outlook, not Access.

He's trying to open the file, but if he's got another database open it's returning that one which isn't the one he wants to update.
Forum: Modules & VBA 01-26-2018, 02:00 PM
Replies: 1
Views: 140
Posted By static
Re: Updating a Word Table

Since this is an Access forum you probably want to post your code so people can run it and understand what you mean.

If your original code created the table at the bookmark, but now the table...
Forum: Modules & VBA 01-26-2018, 01:46 PM
Replies: 2
Views: 183
Posted By static
Re: Shading HTML Tables

To apply style to a tag you either add a style section in the header or apply it directly in the tag.

<div style='font-family:arial;color:blue;background-color: orange;'>Hi I'm blue text on an...
Forum: Forms 01-26-2018, 01:29 PM
Replies: 17
Views: 449
Posted By static
Re: Strange Date Picker Behavior

Sounds like a corrupted memo field.

When memo fields get corrupted their contents can span multiple fields.

If the memo spans non text fields Access usually crashes, but if it only spans text...
Forum: Modules & VBA 01-26-2018, 11:04 AM
Replies: 11
Views: 365
Posted By static
Re: How to check for running instance of access database and then update

GetObject allows you to specify the file path...

With GetObject("D:\dbtest\test_Database.mdb")
.CurrentDb.Execute "insert into tstdata (nwtsk) values (" & sqlstr(test1) & ")"
End With

public...
Forum: Modules & VBA 01-26-2018, 10:30 AM
Replies: 35
Views: 896
Posted By static
Re: me.name vs me.formname

Right click object browser > Show hidden members

If it's hidden you're better off not using it because it could get removed.
Forum: Queries 01-17-2018, 08:41 AM
Replies: 9
Views: 277
Posted By static
Re: How to add a field and auto-populate values

To add new fields to a table you can use sql
alter table TABLENAME add FIELDNAME DATATYPE

to update records in a table you can also use sql
update TABLENAME set FIELDNAME1='some string', ...
Forum: Modules & VBA 12-19-2017, 02:58 PM
Replies: 6
Views: 279
Posted By static
Forum: Modules & VBA 12-19-2017, 02:14 PM
Replies: 5
Views: 272
Posted By static
Re: VB Dlookup Run-time error

The real question is, why do a text search on a table that should have an ID?
Forum: Forms 12-19-2017, 01:50 PM
Replies: 8
Views: 265
Posted By static
Re: Field Requirements based on conditional visibility

But that's not based on any condition.
Have a think about what I wrote above for a bit.
Forum: Forms 12-19-2017, 01:43 PM
Replies: 8
Views: 265
Posted By static
Re: Field Requirements based on conditional visibility

If visibility is based on Issue Type=Bindery then the condition is the same in both cases. Otherwise, I don't understand. I don't see you setting the tag anywhere.

Private Sub...
Forum: Modules & VBA 12-19-2017, 01:10 PM
Replies: 11
Views: 270
Posted By static
Re: Decimal place issue

The only way a numeric data type would show as "Zero" (string) is if you've applied a format to the field...
Forum: Queries 12-18-2017, 11:46 PM
Replies: 15
Views: 574
Posted By static
Re: sql query with variable field names

Variables are values stored in memory that can change.

Association isn't a variable. dest and UPDSQL are.

dim dest as string, myval as string

dest = "table1"
myval = "'ANAR'"
...
Forum: Queries 12-18-2017, 03:15 PM
Replies: 10
Views: 323
Posted By static
Re: Dlookup in a query driving me carzy

Well, yes, but he said he couldn't use joins even though he appears to be using a join.
He's joining one value to another value to return a unique value (? or not) (we don't know what errors he's...
Forum: Queries 12-18-2017, 02:14 PM
Replies: 10
Views: 323
Posted By static
Re: Dlookup in a query driving me carzy

A record can only have one value per field so the dlookup has to return a single value.
In which case he could use a join.
This makes no sense.
Forum: Queries 12-18-2017, 01:39 PM
Replies: 15
Views: 574
Posted By static
Re: sql query with variable field names

As plog said. The table is already a variable. Fields are handled exactly the same way.
Forum: Queries 12-18-2017, 01:37 PM
Replies: 10
Views: 323
Posted By static
Re: Dlookup in a query driving me carzy

use a comma instead of the semicolon.
Forum: Modules & VBA 12-18-2017, 01:31 PM
Replies: 6
Views: 221
Posted By static
Re: add image file to a form on open event

Not sure what your question is.
You can load a picture into an image control just by using its path

image0.picture = "c:\xxx\yyy\picture.gif"

No tables are required.
Forum: Modules & VBA 12-18-2017, 09:12 AM
Replies: 12
Views: 371
Posted By static
Re: How can I determine the "mode" of a Report?

Dim WithEvents rpt As Report

'open the report and get its events, hide this form
Private Sub Command0_Click()
DoCmd.OpenReport "report1", acViewPreview
Set rpt = Reports!report1
...
Forum: Macros 12-15-2017, 04:00 PM
Replies: 20
Views: 1,340
Posted By static
Re: Best use of Macros

Cool. Our applications are all locked up. Nobody else gets at them without our sayso.

I guess this has gone way off topic now. I'm sure OP wasn't talking about triggers/data macros.

But if...
Forum: Macros 12-15-2017, 03:37 PM
Replies: 20
Views: 1,340
Posted By static
Re: Best use of Macros

A user would never have direct access to sql server tables, and recording audit logs can be done easily from code (within a transaction) whereas you'd need a separate trigger for each table being...
Forum: Modules & VBA 12-15-2017, 10:21 AM
Replies: 9
Views: 340
Posted By static
Re: try two (or more) paths in one code

If files are on a network you should use UNC. Then you don't need to worry about mapped drives.

https://pagecommunication.co.uk/2014/07/15/vba-to-convert-a-mapped-drive-letter-to-unc-path/
Forum: Modules & VBA 12-15-2017, 09:21 AM
Replies: 9
Views: 340
Posted By static
Re: try two (or more) paths in one code

Can you say what you are trying to do, instead of telling us what doesn't work?

Thanks.
Showing results 1 to 25 of 500

 
Forum Jump



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


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