Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.20 seconds.
Search: Posts Made By: Galaxiom
Forum: SQL Server Yesterday, 07:30 PM
Replies: 18
Views: 269
Posted By Galaxiom
Re: SQL BE with MS Access FE - Speed up searches

My understanding is that the ODBC interface not only translates tables but can also translate a query if it is not too complex and uses standard SQL functions.



Recent Expensive Queries is in...
Forum: SQL Server Yesterday, 01:15 PM
Replies: 18
Views: 269
Posted By Galaxiom
Re: SQL BE with MS Access FE - Speed up searches

Wherever it can Access queries are translated through ODBC and run on the server.

Sometimes the translated Access queries can be seen on the server. Big ones come up in the Recent Expensive...
Forum: Forms Yesterday, 02:42 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

I assumed txt.Name is a typographical error as I can't see it in the SQL. But maybe it is the crux of the problem?
Forum: Forms Yesterday, 02:40 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

It may be a corruption of the form. Try deleting txtName from the form and adding it again.
Forum: Forms Yesterday, 02:36 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

Sorry I left out the comma between the two parameters. Corrected now,
Forum: Forms Yesterday, 02:27 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

"Name" is a reserved word and should be avoided. It is one of the worst and can cause unexpected problems.

At the very least surround it in square brackets in your query, but preferably change it...
Forum: Forms Yesterday, 02:23 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

It isn't the issue here but instead of this line use:



Execute avoids the series of questions you get with RunSQL
dbFailOnError raises an error if there are any real problems with the Update....
Forum: Forms Yesterday, 02:06 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

Is txtName on a subform?
Forum: Forms Yesterday, 02:01 AM
Replies: 12
Views: 104
Posted By Galaxiom
Re: Update table code

I can't see the issue but your lack of formatting does make it difficult to spot errors.

Are you familiar with using Line Continuation in VBA?
Forum: Queries Yesterday, 01:50 AM
Replies: 2
Views: 59
Posted By Galaxiom
Re: And OR

AND takes precedence over OR unless the parenthesis dictate otherwise.
Forum: Queries Yesterday, 01:47 AM
Replies: 5
Views: 76
Posted By Galaxiom
Re: DateSerial not returning proper prior month last day

Best not. DateValue() would have to be applied to the records. For best performance, always try to avoid applying any functions to the records in the Where clause.
Forum: Modules & VBA Yesterday, 01:43 AM
Replies: 23
Views: 370
Posted By Galaxiom
Re: calculate multi yes/no fields in percentage

Lastname and FirstName do not belong in that table.
Forum: SQL Server Yesterday, 01:27 AM
Replies: 18
Views: 269
Posted By Galaxiom
Re: SQL BE with MS Access FE - Speed up searches

Other things that wreck performance:

Joining local tables to the SQL Server tables.
Access user defined functions in the left side of the Where or in a Join.

On any database, applying any...
Forum: Forms Yesterday, 01:10 AM
Replies: 6
Views: 104
Posted By Galaxiom
Re: Can I load a bound combo box from VBA ?

Your description of having the RowSource come from two different tables suggests you have not normalized properly.

I expect you should have the RowSource records all in the one table with an extra...
Forum: Tables Yesterday, 12:55 AM
Replies: 9
Views: 128
Posted By Galaxiom
Re: Linked Tables

Have you checked if you can connect directly to the back end of your ERP and query the data directly from its tables without going through the export to Excel?

With any luck that data is...
Forum: Forms 12-05-2019, 09:58 PM
Replies: 5
Views: 90
Posted By Galaxiom
Re: Unter form with Max

You need to subquery to identify the event with the latest event grouped by Category then join that back to your main query on Category
Forum: Tables 12-05-2019, 06:12 PM
Replies: 9
Views: 128
Posted By Galaxiom
Re: Linked Tables

Adding more parts with different attributes would then require more tables to be added. Not a good solution.

Consider an EAV (Entity-Attribute-Value) based structure to overcome this. There have...
Forum: Modules & VBA 12-04-2019, 03:35 PM
Replies: 23
Views: 370
Posted By Galaxiom
Re: calculate multi yes/no fields in percentage

I knew just by reading the question title that the problem would be caused by inappropriate table structure. Wanting to Sum across multiple fields is a reliable indicator of normalization issues.
...
Forum: The Watercooler 12-04-2019, 03:40 AM
Replies: 24
Views: 255
Posted By Galaxiom
Re: password storage options

What I meant by "not at home" is that I don't have a login password on my computer at home. I believe your inference linking the two is correct.
Forum: The Watercooler 12-04-2019, 02:57 AM
Replies: 24
Views: 255
Posted By Galaxiom
Forum: The Watercooler 12-04-2019, 12:57 AM
Replies: 24
Views: 255
Posted By Galaxiom
Re: password storage options

That is exactly where I am talking about. I doesn't ask me for a password. Maybe there is a setting for a master password somewhere.



The password readers I have do not required installing....
Forum: The Watercooler 12-03-2019, 08:32 PM
Replies: 24
Views: 255
Posted By Galaxiom
Re: password storage options

Nothing about a master password on my Chrome. I can click a link and go straight in.

I wouldn't store any critical password in any browser.

I have programs that extracted the text from...
Forum: The Watercooler 12-03-2019, 08:23 PM
Replies: 24
Views: 255
Posted By Galaxiom
Re: password storage options

Chrome and Firefox you can see the plain text passwords from the browser.

IE and Edge: Control Panel > User Accounts > Credential Manager > Web Credentials.

Choose the credential. There is a...
Forum: The Watercooler 12-03-2019, 06:46 PM
Replies: 24
Views: 255
Posted By Galaxiom
Re: password storage options

You can simply view the saved passwords in browsers. There was a time when you needed a software tool but that is long gone and you just click a link.
Forum: SQL Server 11-28-2019, 02:15 PM
Replies: 3
Views: 119
Posted By Galaxiom
Re: String_split

Perfect. I have recently been trying to find that series of articles. I read them a few years ago.

I have been able to use String_Split on some tasks where the data has numbered lines but have...
Showing results 1 to 25 of 500

 
Forum Jump



All times are GMT -8. The time now is 05:53 AM.


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