Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 104
Search took 0.01 seconds.
Search: Posts Made By: NearImpossible
Forum: Queries Today, 03:43 PM
Replies: 5
Views: 72
Posted By NearImpossible
Re: Delete Query Criteria

DELETE FROM dbo_db_AddNewTicket WHERE TicketID IN (SELECT TicketID FROM Temp); worked like a charm, and I was using both columns in another query that I copied to make the delete query, but you are...
Forum: Queries Today, 02:54 PM
Replies: 5
Views: 72
Posted By NearImpossible
Delete Query Criteria

When trying to run the following delete query (Screen shot attached), I am getting "Specify the table containing the records you want to delete"

It is due to the Criteria entries and I don't know...
Forum: Macros Today, 01:25 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

if I do this, it orders correctly, however I'm not able to add any new records as its a query result.


I did get it to work how I wanted, I just added a hidden TitleID field to the table and set...
Forum: Macros Today, 01:08 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

This I know, If I enter [ContactTitle] in the OrderBy property, it sorts them alphabetically. Would I would like it to sort by is the TitleID of the associated title so instead of sorting the table...
Forum: Macros Today, 12:56 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

I'm not trying to sort the dropdown menu, i'm trying to sort the table by the selected value of the dropdown menu, see attached sample.

I would like to sort the table based on the TitleID of the...
Forum: Macros Yesterday, 08:00 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

This particular table is the contacts table [Title] [Name] [WorkPhone] [CellPhone] [Email]

and what I was hoping to accomplish was give the user the ability to insert a new row in the middle of...
Forum: Macros Yesterday, 07:23 PM
Replies: 23
Views: 601
Posted By NearImpossible
Forum: Macros Yesterday, 06:01 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

Revisiting this thread as I am running into another issue.

What I would like to do is give the user the ability to insert a row with the right click menu, which I added that command, however...
Forum: General Yesterday, 02:07 PM
Replies: 6
Views: 112
Posted By NearImpossible
Re: View in Windows vs Tabs

That does work, however it also affects the layout of the database while in use, is there anyway to have it act like that only while in design mode so I could have each open in its own window, but if...
Forum: General Yesterday, 01:58 PM
Replies: 6
Views: 112
Posted By NearImpossible
View in Windows vs Tabs

Is it possible to view a form, query, report, etc. in a separate window vs a tab while working on it?

The reason i'm asking is I would like to be able to see the columns of one table while...
Forum: Modules & VBA 12-03-2019, 07:42 PM
Replies: 37
Views: 589
Posted By NearImpossible
Re: Export data fields based on checkboxes on Form

You can try something along the lines of

Dim rst As DAO.Recordset

Open "PATH OF TEXT FILE" For Output As #1

Set rst = CurrentDb.OpenRecordset("Select [DATA FIELD] from [TABLE] Where [CHECK...
Forum: Reports 12-02-2019, 09:45 AM
Replies: 7
Views: 114
Posted By NearImpossible
Re: Desired Grouping Field Not Available

That's good to know, so what is the magic number of characters before its not longer group-able?
Forum: Reports 12-02-2019, 09:37 AM
Replies: 7
Views: 114
Posted By NearImpossible
Re: Desired Grouping Field Not Available

Please see attached, apparently its an issue with the nvarchar(Max) type as nvarchar(50) types show
Forum: Reports 12-02-2019, 09:29 AM
Replies: 7
Views: 114
Posted By NearImpossible
Re: Desired Grouping Field Not Available

SELECT *
FROM EquipmentOrders
WHERE EquipmentOrders.[Awaiting Payment]=1
Forum: Reports 12-02-2019, 09:26 AM
Replies: 7
Views: 114
Posted By NearImpossible
Desired Grouping Field Not Available

Hello all,

I have a select query to return all data based on a checkbox, which works great.

The fields being returned are as follows: OrderID, Facility, Description, OrderDate, PurchNum,...
Forum: Queries 11-23-2019, 08:38 AM
Replies: 8
Views: 190
Posted By NearImpossible
Re: Search Between Dates/Times

Thanks to both of you for the response, not sure why I didn't think about bumping then end string by a day.

Changed the end string search to...
Forum: Queries 11-23-2019, 08:22 AM
Replies: 8
Views: 190
Posted By NearImpossible
Re: Search Between Dates/Times

I figured something as such happened, no problem...
Forum: Queries 11-23-2019, 07:59 AM
Replies: 8
Views: 190
Posted By NearImpossible
Search Between Dates/Times

I have a table that is storing the date and time that a transaction occurs in the following format "10/20/2019 5:57:11 PM"

I am trying to do a "Start" and "End" range search with
...
Forum: Modules & VBA 11-06-2019, 08:56 PM
Replies: 14
Views: 294
Posted By NearImpossible
Re: Changing Record Source

After looking at this a little closer, I guess I was looking more for pre-populated field sources from the underlying form vs a different source object.

I was able to make it work using unbound...
Forum: Modules & VBA 11-03-2019, 12:00 PM
Replies: 14
Views: 294
Posted By NearImpossible
Re: Changing Record Source

yes, I wanted to change the Source Object so please forgive my wording as obviously RecordSource refers to something completely different, but as previously Identified by DBguy, Source Object is for...
Forum: Modules & VBA 11-03-2019, 10:46 AM
Replies: 14
Views: 294
Posted By NearImpossible
Changing Record Source

Wondering if someone can point out the obvious as I seem to be missing it more and more lately.

I would like to use the same form for entering notes, however, depending on underlying form that it...
Forum: Macros 10-30-2019, 06:43 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

I put the macro in the wrong spot on the properties :banghead:, its working on the form, however if I add it to a text box, I get the regular Right Click menu.

Ill check out your demo


EDIT: I...
Forum: Macros 10-30-2019, 06:37 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

Could you post that zip file here? Its telling me I need an account to download it.

Here are the screen shots of the macros and form properties, I just used the same names as the tutorial for the...
Forum: Macros 10-30-2019, 06:14 PM
Replies: 23
Views: 601
Posted By NearImpossible
Re: Custom Right Click Menu

That is the story of my life :banghead:
Forum: Macros 10-30-2019, 06:06 PM
Replies: 23
Views: 601
Posted By NearImpossible
Custom Right Click Menu

I am using the full version of access to create my database, however the end users only have the Access Run-Time so there is no Right Clicking.

I followed the steps shown here...
Showing results 1 to 25 of 104

 
Forum Jump



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