Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.30 seconds.
Search: Posts Made By: theDBguy
Forum: SQL Server Yesterday, 06:20 PM
Replies: 17
Views: 177
Posted By theDBguy
Re: Set Default Values

Sounds good. Thanks!
Forum: SQL Server Yesterday, 06:18 PM
Replies: 17
Views: 177
Posted By theDBguy
Re: Set Default Values

Hi. What do you get if you run this SQL?
SELECT * FROM sys.default_constraints;You can compare the results after you modify the table to add a new column.
Forum: Forms Yesterday, 06:14 PM
Replies: 3
Views: 42
Posted By theDBguy
Re: ?lookup form function

Hi icruy09. Welcome to AWF!
Forum: SQL Server Yesterday, 06:06 PM
Replies: 17
Views: 177
Posted By theDBguy
Re: Set Default Values

Hi. If you're running the ADD constraint again, it might be a good idea to DROP it first before adding it again. Just a thought...
Forum: Modules & VBA Yesterday, 06:02 PM
Replies: 18
Views: 156
Posted By theDBguy
Re: Populate the name of the active control on focus in a form.

Hi. Try the attached modified version. It's just one of many ways to do the same thing.
Forum: SQL Server Yesterday, 01:33 PM
Replies: 17
Views: 177
Posted By theDBguy
Re: Set Default Values

Can you post your final SQL statement? Thanks for sharing.
Forum: General Yesterday, 01:05 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Hi. Try adding a new Textbox to the form and change the name in the macro to the name of the new Textbox. Let's see if you still get the same error.
Forum: General Yesterday, 12:57 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Hi. I'm not sure about that. Okay, I found the purchase find form and made a small change. However, without the backend, I couldn't test if it makes any difference, so you'll have to test it for me.
Forum: General Yesterday, 12:52 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Then, my next guess is maybe that form has gotten corrupt. Try replacing it with one from a backup copy of the db. Either that or try to recreate the dropdown and macro from scratch.
Forum: General Yesterday, 12:45 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Okay. That macro has two actions on it. The first one moves the focus to a control called CompanyName. The second action does a search in that field for the value in the FindSupplier control. Are you...
Forum: General Yesterday, 12:43 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Hi. How exactly are you determining the name of the form when I ask you for it? Did you give me an exact copy of the frontend you're using?
Forum: General Yesterday, 12:39 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Sorry, I don't see any form with that name either.


https://www.access-programmers.co.uk/forums/attachment.php?attachmentid=76573&stc=1&d=1568839149
Forum: Forms Yesterday, 12:34 PM
Replies: 4
Views: 58
Posted By theDBguy
Re: Login Screen on forum

Hi. Probably, but I can't tell you what exactly if I don't understand what you're trying to do. Can you post a sample copy of your db?
Forum: General Yesterday, 12:32 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Right, that's where you would change the code. What is the name of this form, so I could give it a try on my end as well?
Forum: Forms Yesterday, 12:31 PM
Replies: 7
Views: 78
Posted By theDBguy
Forum: Forms Yesterday, 12:24 PM
Replies: 4
Views: 58
Posted By theDBguy
Re: Login Screen on forum

Hi. I thought you were talking about the login page on this website. Typically, you would have a table listing all the authorized users. If so, that table should have a primary key. In your login...
Forum: General Yesterday, 12:20 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

I was going to do it for you, if I only knew which form it was. To change the code, you do the steps I posted in post #7...
Forum: Forms Yesterday, 12:17 PM
Replies: 7
Views: 78
Posted By theDBguy
Re: Form on a loop? "duplicate values in the index, primary key, or relationship."

Hi. Welcome to AWF! I'm not sure there's enough information there to help us figure out what you're trying to do. Are you able to post a sample copy of your db?
Forum: General Yesterday, 12:07 PM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Here you go, but it probably won't help you. Remember, since I don't have your data file, I have to open it in design/dev mode.


...
Forum: General Yesterday, 11:53 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Sorry. Still, it doesn't have any form called "purchase orders" or "view purchase orders." It still has "PurOrders" and "PuchaseFind." However, PurchaseFind does not have any code behind the dropdown...
Forum: General Yesterday, 11:44 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

In the code I'm seeing, the following line is in red:
.FindFirst "[CompanyName] = " & Chr(34) Me![FindSupplier] & Chr(34)The reason for that is it's missing an ampersand like so: ...
Forum: General Yesterday, 11:42 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Hi. I don't see any form with that name. There is a "PurOrders" form, but it doesn't look anything like the images you posted earlier. I found one that looks similar called "PurchaseFind", but it...
Forum: General Yesterday, 11:39 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Hi. Thanks! What's the name of the form with the problem?
Forum: General Yesterday, 11:32 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

No, maybe not. Let's try this for now, can you post a copy of the front end first? We just really need to see the form and the code. We'll worry about the backend later.
Forum: General Yesterday, 11:22 AM
Replies: 57
Views: 272
Posted By theDBguy
Re: Help with converting database from 2003 to 2010

Ah, okay. It might be simpler to create a blank database file and then import the data definition into it.


1. Create a new blank database
2. Go to External Data tab and click on Import Access...
Showing results 1 to 25 of 500

 
Forum Jump



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