Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.11 seconds.
Search: Posts Made By: theDBguy
Forum: General Today, 02:58 PM
Replies: 7
Views: 46
Posted By theDBguy
Re: Corrupt database

That depends on the potential return on investment (ROI). How important are the lost data and how much are you willing to pay to "maybe" recover it? If you have a good backup plan, you should only...
Forum: General Today, 02:55 PM
Replies: 35
Views: 242
Posted By theDBguy
Re: A Question of Trust

Misuse privileges, who me? Never! :D
Forum: Forms Today, 02:50 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

Hi. That's not really the same as what I thought you were asking. I thought you were wanting to know how to transfer/copy the CustomerID value from one form to another. A CustomerID value is just one...
Forum: Forms Today, 02:44 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

Hi. If you don't mind, I do have a couple of questions about it.


What is the difference between Pick and Drop locations?
In tblOrders, does EmployeeID refers to the person who took the order?...
Forum: Queries Today, 02:36 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Yes, it should work too, but I didn't see the need for it because the OP is not displaying the same column twice.
Forum: Queries Today, 02:34 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Hi. Glad to hear it worked for you. We all learned something. Good luck with your project.
Forum: Queries Today, 02:34 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

That's interesting. I didn't get any errors.


https://access-programmers.co.uk/forums/attachment.php?attachmentid=77452&stc=1&d=1573770819

...
Forum: General Today, 02:29 PM
Replies: 35
Views: 242
Posted By theDBguy
Re: A Question of Trust

No, the app won't run, initially, because VBA (or perhaps more accurately, the Content) is disabled as a default. But as soon as the user clicks the "Enable Content" button, then the app will run. I...
Forum: Queries Today, 02:23 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Hi. But if you have the following:
SELECT ID, TableName.ID AS ID

FROM TableNameI am saying the second ID column will be empty.
Forum: General Today, 02:20 PM
Replies: 7
Views: 46
Posted By theDBguy
Re: Corrupt database

That's what I was trying to say earlier. I wasn't sure if you're affected, but it couldn't hurt to check if the recommended solutions work for your situation too. As for recovering "lost" records,...
Forum: Queries Today, 02:18 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Okay, let's see if this works (based on Gasman's suggestion):
SELECT tblCompany.CompanyName AS Company, tblContacts.ContactName AS [Contact Name], tblContacts.Title AS [Contact Title], ...
Forum: Queries Today, 02:14 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Fair enough. I just gave it a try and didn't get any errors. However, if two columns with the same name are to be displayed, at least in my limited experience, one of them will show up empty.
Forum: Forms Today, 02:07 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

No, the opposite. Add your order form as a subform to the customer form (just like in the sample in the link I posted earlier).


PS. Unless, of course, each order belongs to multiple customers....
Forum: Queries Today, 02:05 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

I tested it out of curiosity and it worked for me! However, I haven't really ran into any issues where I needed it, but at least now I won't have to worry if I do.
Forum: Queries Today, 02:04 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Hi Danick. Please post your query, and we'll try to help you put this in.
Forum: General Today, 01:55 PM
Replies: 7
Views: 46
Posted By theDBguy
Re: Corrupt database

Again, not sure it this affects your, but you could start here (https://www.devhut.net/2018/06/13/access-bug-database-is-in-an-unrecognized-format/) to see what I meant.
Forum: SQL Server Today, 01:53 PM
Replies: 5
Views: 49
Posted By theDBguy
Re: difference between oracle and SQL

Hmm, I am wondering what Oracle has to do with this...
Forum: Forms Today, 01:52 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

Okay, so back to my original question then. Have you considered using it for your orders form, so you don't have to worry about copying the customer ID back and forth? Just wondering...
Forum: Queries Today, 01:50 PM
Replies: 27
Views: 153
Posted By theDBguy
Forum: General Today, 01:46 PM
Replies: 7
Views: 46
Posted By theDBguy
Re: Corrupt database

Can't remember if the recent issue with the Windows Updates affect MDBs, but maybe they do. Have you looked into it yet? For example, what version of Windows are you using and what build?
Forum: Forms Today, 01:38 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

Hi Fira. Thanks. But you didn't answer my question. Are you or are you not familiar with creating subforms...
Forum: Queries Today, 01:28 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

I doubt it would make any difference, but it couldn't hurt to try.
Forum: Forms Today, 01:28 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

I would be interested in seeing the forms...
Forum: Forms Today, 01:23 PM
Replies: 18
Views: 100
Posted By theDBguy
Re: Inserting current from open form to another form.

Hi. Are you familiar with a form/subform setup? I was just saying if you could embed your order form as a subform to your customer form, then assigning the customer id to each order will be done for...
Forum: Queries Today, 01:20 PM
Replies: 27
Views: 153
Posted By theDBguy
Re: Circular reference when using filed name in IIF query

Hi. The only way I could think of is to use another query on top of your current query, so you can change the name back.
Showing results 1 to 25 of 500

 
Forum Jump



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