Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 123
Search took 0.02 seconds.
Search: Posts Made By: Solo712
Forum: Modules & VBA 10-30-2019, 09:32 AM
Replies: 47
Views: 888
Posted By Solo712
Re: can't figure where I'm going wrong

Yes, I think Gasman is right and the code below should do it:

Set rs = db.OpenRecordset("SELECT * FROM Tbl_Tickets " & _
"WHERE DatePart("yyyy",DateOpened) = " & CmbYear, dbOpenDynaset)

...
Forum: Modules & VBA 05-19-2019, 02:15 PM
Replies: 22
Views: 376
Posted By Solo712
Re: Is Day In String of days

A simpler way to do it would be :NextFriday = pDate + 8 - Weekday(pDate, vbFriday)

Best,
Jiri
Forum: General 05-06-2019, 09:45 AM
Replies: 25
Views: 573
Posted By Solo712
Re: Invoice. Dirty fix or redo?

Now I see why you had qualms about structure. You would be much better off splitting the invoice into two tables: header and detail and and have customers and parts in separate tables also. There...
Forum: General 05-06-2019, 07:08 AM
Replies: 25
Views: 573
Posted By Solo712
Re: Invoice. Dirty fix or redo?

I don't see anything wrong with the table structurally, on what you have shown. But would it not be simpler to create text fields for the parts and enter (or correct) their quantity directly rather...
Forum: General 05-04-2019, 06:46 PM
Replies: 20
Views: 520
Posted By Solo712
Re: Moving from single user to two users on a home network

Sorry, pal, none of this makes any sense to me. I have never heard or seen anyone writing about Front End in an unsplit database, and the notion itself is bafflegab. In shared environments where the...
Forum: General 05-04-2019, 08:51 AM
Replies: 20
Views: 520
Posted By Solo712
Re: Moving from single user to two users on a home network

This is what Putin calls "polnyi chush"! First of all, splitting the database does not protect against collisions. Both users would be accessing the same back-end! Duh! Second, there is absolutely no...
Forum: Modules & VBA 05-02-2019, 08:32 PM
Replies: 43
Views: 986
Posted By Solo712
Re: A better way than a bunch of If-Then DLookUp's

Doc, it's always good to see other solutions especially solutions that work. Unfortunately, in this thread at least, most people are into theory which is for some of us hard to follow. A little...
Forum: Modules & VBA 05-02-2019, 04:18 AM
Replies: 43
Views: 986
Posted By Solo712
Re: A better way than a bunch of If-Then DLookUp's

Not quite true, Doc. Chuck has 17 users, each assigned a role. There are 131,072 possible roles that he can assign. :)

Best,
Jiri
Forum: Modules & VBA 05-01-2019, 04:51 PM
Replies: 43
Views: 986
Posted By Solo712
Re: A better way than a bunch of If-Then DLookUp's

Hi,
the sub-table is a good idea but there should be a single variable per user (long integer if you are not planning to go over 32 reports, or a string) that manages the individual controls for...
Forum: Modules & VBA 04-03-2019, 08:35 PM
Replies: 34
Views: 563
Posted By Solo712
Re: Different Saves

I suspect the facility of saving design changes at run time was meant above all for projects where controls are built dynamically during a session.

Cheers,
Jiri
Forum: Modules & VBA 02-01-2019, 05:13 PM
Replies: 29
Views: 470
Posted By Solo712
Re: Cannot assign a value

This error sometimes happens if your Control Source (on the Properties Data Tab) does not agree with the Name (on the Properties Other Tab). Specifically, you need to refer to the Mil_Lic field by...
Forum: General 01-31-2019, 05:23 AM
Replies: 8
Views: 159
Posted By Solo712
Re: Unrecognized database format message

I get this message sometimes when I copy a db to a different machine with a different (,usu lower,) version of Access. It looks scary but it goes away when I decompile and recompile the Front End.
...
Forum: General 01-26-2019, 05:59 AM
Replies: 15
Views: 348
Posted By Solo712
Forum: General 01-25-2019, 07:32 PM
Replies: 15
Views: 348
Posted By Solo712
Re: Severe problems after Win 10 & Office 365 update

Hi Frank,
whenever I run into the "unrecognized format" issue after I port my app into a new machine, newer OS or Access version the first thing I do is decompile and recompile. This usually...
Forum: Modules & VBA 01-18-2019, 09:56 AM
Replies: 19
Views: 461
Posted By Solo712
Re: Brainstorming - Open for Suggestions

Not knowing your setup, I am not sure. Normally, the matching of the vendor/job (partdesc code, purchase price(?)) would be done through purchase order module.

Best,
Jiri
Forum: Modules & VBA 01-18-2019, 09:40 AM
Replies: 19
Views: 461
Posted By Solo712
Re: Brainstorming - Open for Suggestions

Hi,
a lot depends on what you use to download data. What would be the input dataset:Excel, CSV,... ? Then, since you say that the "dummy" key - manually inserted, I assume - will identify the...
Forum: Modules & VBA 01-14-2019, 07:16 PM
Replies: 6
Views: 665
Posted By Solo712
Re: Billing Year

Be it as it may, your code will not fix anything - in theory or otherwise. This is just bad design that needs to be fixed. Period. You can easily rewrite the dropdown box to show month and year. Say...
Forum: Tables 01-05-2019, 12:50 PM
Replies: 5
Views: 594
Posted By Solo712
Re: Employee Table

Hi,
basically you are looking at two different external tables. One is employee wage history, as Ranman suggests, and the other is Employee Attendance/Absence which tracks vacations, leaves,...
Forum: Modules & VBA 01-05-2019, 12:24 PM
Replies: 7
Views: 353
Posted By Solo712
Re: Prohibit Auto Save of MS Access form Data

The trick I am using is this: Create a boolean variable that is visible by the whole form, say StopUntilSaved. In the Form_Current event set it to True.
Then place this as first statements in you...
Forum: General 01-01-2019, 10:28 AM
Replies: 23
Views: 468
Posted By Solo712
Re: Is Access the best way to go about this project?

I take it you mean 'storage replication' rather than 'server mirroring'. I am not aware Microsoft has server mirroring capability; actually I believe the idea of mirroring networked servers went out...
Forum: Modules & VBA 12-31-2018, 10:59 AM
Replies: 2
Views: 279
Posted By Solo712
Re: Auto copy a copy and open it.

You need to make sure that the access to the Timer event is restricted to copy the new front end only once. The best way to handle this is to have a small update table on both the Front- and Back...
Forum: Tables 12-19-2018, 08:12 PM
Replies: 4
Views: 450
Posted By Solo712
Re: Restrict one record to TRUE in a boolean field and all other records to FALSE

Hi ,
I don't think anything would be bulletproof here but I would make that "pointer" table Minty suggested a "Usys" table and hide it in the navigation panel.

Best,
Jiri
Forum: Modules & VBA 12-05-2018, 10:32 PM
Replies: 19
Views: 964
Posted By Solo712
Re: List files to table and include date modified

Hello hubelea,

My apologies for the earlier post. I felt sure I was looking at an object. At any rate, I went back and fixed the routine. Took a while to figure out but there was a problem with...
Forum: Modules & VBA 11-27-2018, 07:20 AM
Replies: 10
Views: 355
Posted By Solo712
Re: Open specific form in external DB

Interesting, an almost identical OP was run here two years ago. CJ London gave the most obvious reply.

https://access-programmers.co.uk/forums/showpost.php?p=1509685&postcount=2

Another way to...
Forum: Forms 12-19-2017, 04:05 PM
Replies: 8
Views: 419
Posted By Solo712
Re: Field Requirements based on conditional visibility

You are right, should be ctl.Visible = True

Best,
Jiri
Showing results 1 to 25 of 123

 
Forum Jump



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