Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 3.97 seconds.
Search: Posts Made By: Cronk
Forum: General 10-02-2019, 12:14 PM
Replies: 11
Views: 243
Posted By Cronk
Re: Training Database

From what I can glean from your requirements, the following table structure will cover everything except for training revision aspect which you can set aside for the moment until you get your head...
Forum: General 10-01-2019, 09:29 PM
Replies: 11
Views: 243
Posted By Cronk
Re: Training Database

I agree with Ranman. There is something wrong in the design when you need multiple tables all with the same structure, just relating to different situations.

Can you clarify your requirements...
Forum: Modules & VBA 09-30-2019, 10:33 AM
Replies: 15
Views: 220
Posted By Cronk
Re: Recordset Operation

Try
Dim rRsl As DAO.Recordset
Dim dbs As DAO.Database

Set dbs = CurrentDb

With dbs.OpenRecordset("DUPLICATES_2018", dbOpenSnapshot)
If Not (.BOF And .EOF) Then...
Forum: General 09-29-2019, 10:37 AM
Replies: 13
Views: 215
Posted By Cronk
Re: Width, Height, Top, Left Properties keep jumping around / won't accept value

If it really is that critical, in your form load event,
me.YourLabelName.top = 30
Forum: Modules & VBA 09-24-2019, 02:13 AM
Replies: 8
Views: 92
Posted By Cronk
Re: filter report

Ravi


If Area is a text field, there is a missing quote there.


... "[Area]='" & Me.cbolocationbrief & "'"
Forum: Modules & VBA 09-20-2019, 10:33 AM
Replies: 3
Views: 103
Posted By Cronk
Re: Data Type Conversion Error

The correct syntax is
s = "Equipment Order - Due " & Rs("[Equipment Order Due]")


Alternatively
s = "Equipment Order - Due " & Rs![Equipment Order Due]


What is supposed to happen if there...
Forum: Modules & VBA 09-07-2019, 11:41 AM
Replies: 10
Views: 994
Posted By Cronk
Re: Runtime Error 3134

Also by the names, the fields
LOTSIZE, SAMPLEQTY, REJECTQTY, TOTREJECTED
would appear to be numeric


If so, remove the single quotes around the data being inserted.
Forum: General 09-05-2019, 05:03 PM
Replies: 18
Views: 266
Posted By Cronk
Re: A query to call in VBA

The complete listing of all owners is in tbl_Customers, no? You have set up your database properly. My point is that your current tbl_CarsOwners has information about the cars, one of which is...
Forum: General 09-05-2019, 10:38 AM
Replies: 18
Views: 266
Posted By Cronk
Re: A query to call in VBA

As I wrote in #9, I was suggesting the table should be named tblCars with the key field CarID.


The car entity has a number of properties, the owner being only one of the properties with the...
Forum: General 09-04-2019, 11:39 AM
Replies: 18
Views: 266
Posted By Cronk
Re: A query to call in VBA

In the first post, there was reference to a combo bound to Owner_ID. This is the key field in a table called tbl_CarOwners. It seems more appropriate that this should be called tblCars because it...
Forum: Tables 08-28-2019, 11:09 AM
Replies: 10
Views: 275
Posted By Cronk
Re: Sudden speed issue with back end

There has been previous reference in this thread to the need for indexing. Any field which is used in any sort or selection operation (query/recordset) should be indexed for improved performance.
...
Forum: Modules & VBA 08-26-2019, 06:21 PM
Replies: 14
Views: 198
Posted By Cronk
Re: Number data type showing negative (-) numbers

In the original post, was that a screen shot of the table? It might be that Stock on Order is treated as negative usage, depending on system design. How do the numbers appear on form(s) relating to...
Forum: Modules & VBA 08-21-2019, 10:59 AM
Replies: 17
Views: 381
Posted By Cronk
Re: Billing ethics for managing access database

@ adewale4favour
I see that you have edited your original post for more clarity that you are in fact seeking are seeking input on billing methods for future work with that company.


I have...
Forum: General 08-21-2019, 10:32 AM
Replies: 5
Views: 119
Posted By Cronk
Re: Form/Table get a MAX of a field based on combobox filter

If you want to ensure that LAIM and CodeSequence are unique, create a composite index on both fields (search for "create a composite unique index) and set its property to Unique. That way Access...
Forum: General 08-20-2019, 11:03 AM
Replies: 6
Views: 112
Posted By Cronk
Re: AO Index is not an Index in this Table

The OP wrote



If your system is split FE/BE, then if there is a table(s) in the front end, it should be a look up table. I'd import all non table objects into a new db and re-create the lookup...
Forum: Tables 08-08-2019, 10:50 AM
Replies: 10
Views: 190
Posted By Cronk
Re: table update

Have you set db to a database object?

Dim strsql As String
set db = currentdb
strsql = "UPDATE Sections_New INNER JOIN Sections ON Sections_New.SectionID = Sections.SectionID SET...
Forum: Tables 07-31-2019, 11:44 AM
Replies: 3
Views: 99
Posted By Cronk
Re: Unable to append records to linked table in MS Access. Key Violations issue

The same issue would arise if there was another index which did not allow duplicate numbers.
Forum: Modules & VBA 07-24-2019, 12:16 PM
Replies: 8
Views: 189
Posted By Cronk
Re: Automatically Add New Users and Open to their page

There is a logic problem with your code in that
UsrLogin = DLookup("UserLogin", "dbo_db_UserLogins")
will return Null for the first user but after the first user has been entered, it will return...
Forum: Modules & VBA 07-21-2019, 08:04 AM
Replies: 16
Views: 334
Posted By Cronk
Re: Summing date ranges

If you group on the date fields, the query will show every single instance of each date range and employee.


If you create another query including the date ranges, you could join the two queries...
Forum: Modules & VBA 07-19-2019, 01:23 PM
Replies: 16
Views: 334
Posted By Cronk
Re: Summing date ranges

Drop TaskID and Start/Enddates from the query. Group on EmployeeID (not sum) and sum the DaysWorked, your query will show the aggregate for each employee.


But if you read my post earlier, you...
Forum: General 07-18-2019, 11:41 AM
Replies: 32
Views: 505
Posted By Cronk
Re: Creating an Amortisation Schedule in Access

I agree,. It seems a lot of work to put emulate it in Access when a spreadsheet is ideal. Incidentally, it looks more like a payment schedule rather than amortization which is write down of an...
Forum: General 07-17-2019, 09:23 AM
Replies: 18
Views: 251
Posted By Cronk
Re: Debug Not in List Event

In your initial post, you said the INSERT was working in one instance but you got an error in the other.


I gave you a method, which not only checks the sql, but also to check what the issue was,...
Forum: Tables 07-16-2019, 12:47 PM
Replies: 3
Views: 173
Posted By Cronk
Re: Caculated Field Expression not working

IIf([Age]<=-2,"Emergency",IIf([Age]=-1<=0,"Critical",IIf([Age]=1,"High",IIf([Age]>=2<=3,"Medium",IIf([Age]>3,"Low","No Date")))))


The problem is with the bits in red. They will give a true...
Forum: General 07-16-2019, 12:31 PM
Replies: 18
Views: 251
Posted By Cronk
Re: Debug Not in List Event

In the code that is not working, I would put a break point, and use debug.print to get the actual sql that you are trying to run, and paste that into a new query. Either the sql string will show up...
Forum: Modules & VBA 07-12-2019, 10:46 AM
Replies: 16
Views: 334
Posted By Cronk
Re: Summing date ranges

An alternate to Datediff is to subtract the two dates. But but be aware for someone worked July 6, 7 and 8 (3 days) that


DateDiff("d", #July 6 2019#, #July 8 2019#)
as well as

#July 8...
Showing results 1 to 25 of 500

 
Forum Jump



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