Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 359
Search took 0.06 seconds.
Search: Posts Made By: psyc0tic1
Forum: Modules & VBA 02-28-2019, 11:05 AM
Replies: 3
Views: 92
Posted By psyc0tic1
Re: Syntax Error Missing Operator

So simple but eluded me... thanks guys... worked perfect
Forum: Modules & VBA 02-28-2019, 10:57 AM
Replies: 3
Views: 92
Posted By psyc0tic1
Syntax Error Missing Operator

I have a form for looking up records. There is a text field on the form to put in a number that can be found in the table (tbl_data) field named 8DNumber which is a number field.

A subform in...
Forum: Modules & VBA 01-11-2019, 01:49 PM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

That is a good idea about the message box... I think I will do that... as far as connecting to their computer... they are in Viet Nam... and I am not a network admin so this probably will be...
Forum: Modules & VBA 01-11-2019, 11:22 AM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

The printout is
UPDATE tbl_users SET Version = 'v018' WHERE ID = 1
ID = 1 is my login

I tested the users login that is having the issue on my computer and their login works and their version...
Forum: Modules & VBA 01-10-2019, 01:17 PM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

This is the whole block of code
Private Sub Form_Open(Cancel As Integer)
Dim dbs As DAO.Database
Dim FEVersion As Variant

Set dbs = CurrentDb
If Credentials.AccessLvlID = 0...
Forum: Modules & VBA 01-10-2019, 01:16 PM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

I don't have an issue on my computer... it is happening to one of my users overseas. I have no idea what version of office they have or what version of windows they are using. Terrible language...
Forum: Modules & VBA 01-10-2019, 01:12 PM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

I do not know how to do that
Forum: Modules & VBA 01-10-2019, 12:27 PM
Replies: 52
Views: 1,743
Posted By psyc0tic1
Re: Check for newest DB version?

Sorry to post again in this long thread but Microsoft has done something to access that is causing this line to throw the 3144 Syntax error in UPDATE statement error
DoCmd.RunSQL "UPDATE tbl_users...
Forum: Modules & VBA 11-16-2018, 08:17 AM
Replies: 28
Views: 543
Posted By psyc0tic1
Re: Access closing unexpectedly after editing VBA

Have you tried removing that?

Does it crash as you described if you open the database by holding down the SHIFT key and clicking the DB? That should bypass the AutoExec and any other code.
Forum: Forms 11-14-2018, 11:23 AM
Replies: 6
Views: 158
Posted By psyc0tic1
Re: Best Practice for deleting single record from sub form

I always read and try to help... most times I am not smart enough to help :rolleyes:
Forum: Forms 11-14-2018, 10:41 AM
Replies: 6
Views: 158
Posted By psyc0tic1
Re: Best Practice for deleting single record from sub form

Sorry about that Colin... I didn't know you had given him code already and the code I posted is from my database (I found it somewhere else) for a form I am working on.
Forum: Forms 11-14-2018, 07:32 AM
Replies: 6
Views: 158
Posted By psyc0tic1
Re: Best Practice for deleting single record from sub form

use this
Option Compare Database
Option Explicit

Private Sub NameOfYourDeleteButton_Click()
Dim strSQL As String

strSQL = "DELETE NameOfTable.* FROM NameOfTable WHERE...
Forum: Modules & VBA 11-13-2018, 10:37 AM
Replies: 2
Views: 111
Posted By psyc0tic1
Re: Delete created folders when deleting record

Indeed... the users will name the attachments the same all the time i.e. IMG 1.jpg, IMG 2.jpg etc. which is the reason for the folder creations the way they are. I also do not want to delete any...
Forum: Modules & VBA 11-13-2018, 09:25 AM
Replies: 15
Views: 372
Posted By psyc0tic1
Re: File copy problem

Did I actually help someone for a change?!!
Forum: Modules & VBA 11-13-2018, 08:51 AM
Replies: 15
Views: 372
Posted By psyc0tic1
Re: File copy problem

Shouldn't that be:

FileStructure = "\\CMASERVER\Data\Louise\SLA\" & msCustomer & "\" & msDate & "\" & msDateFull & " - " & msJob & "\Measurement Report\" & msMethod & " Measurement...
Forum: Modules & VBA 11-13-2018, 08:48 AM
Replies: 15
Views: 372
Posted By psyc0tic1
Re: File copy problem

Your code shows .xlxs as the file extension but it should be .xlsx
Forum: Modules & VBA 11-13-2018, 08:45 AM
Replies: 2
Views: 111
Posted By psyc0tic1
Delete created folders when deleting record

I am asking for help on another part of the attachments thread located here:
https://www.access-programmers.co.uk/forums/showthread.php?t=247009

I didn't want to add it to the bottom as it is...
Forum: Modules & VBA 11-09-2018, 12:59 PM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

In the mean-time... the child table worked to solve the 3197 error
Forum: Modules & VBA 11-09-2018, 11:47 AM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

I think the misunderstanding may be my lack of explanation. There are not 3 subforms trying to update the same record at the same time. Depending on situations... the 3 subforms may not be used at...
Forum: Modules & VBA 11-09-2018, 11:34 AM
Replies: 41
Views: 4,250
Posted By psyc0tic1
Re: Code to Upload and Save Attachments External to Access 2007

That has been worked out in the code I posted above above.

@AlphaMike... The code I posted above will do all of that. You will need to change the directory creation code to meet your needs and...
Forum: Modules & VBA 11-09-2018, 08:14 AM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

If I understand what you are suggesting... my database already uses tab control for the forms (including form #3). Are you suggesting making the 3 sub-forms used on form #3 tab controls themselves?
...
Forum: Modules & VBA 11-09-2018, 05:14 AM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

Well back in Post #3 I explained that I discovered the reason and was making the new table to solve it.

As for the question of WHY I believe that the form and sub-form should both be based on the...
Forum: Modules & VBA 11-08-2018, 09:00 PM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

Scolded for not posting enough information and too much information at the same time
Forum: Modules & VBA 11-08-2018, 08:58 PM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

Wow... Pardon me and never mind
Forum: Modules & VBA 11-08-2018, 05:38 PM
Replies: 13
Views: 379
Posted By psyc0tic1
Re: Run-Time Error 3197 (please read anyway)

Sorry... After all the threads regarding my database... I didnt think I needed to explain those details again.

Database is split.
Only me in it at the time... No other users.
The form and sub...
Showing results 1 to 25 of 359

 
Forum Jump



All times are GMT -8. The time now is 12:43 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