Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 500
Search took 0.07 seconds.
Search: Posts Made By: theDBguy
Forum: General Today, 02:24 PM
Replies: 1
Views: 29
Posted By theDBguy
Re: Access bug on Update queries

That's correct. As mentioned earlier (https://access-programmers.co.uk/forums/showthread.php?t=307918). Keep spreading the word.
Forum: Tables Today, 02:11 PM
Replies: 11
Views: 104
Posted By theDBguy
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

Hi. Deleting a lookup from the table simply means changing the Display Control from either Combobox or Listbox to Textbox under the Lookup tab.
Forum: Tables Today, 12:55 PM
Replies: 11
Views: 104
Posted By theDBguy
Re: Lookup Fields are evil? Or is this ok? Need a little guidance

Hi. Lookup fields have nothing to do with relationships, not really. So, if you have any lookup fields in your table, then take them out. What your image is showing are foreign keys, which are fine...
Forum: Introduce Yourself Today, 11:51 AM
Replies: 3
Views: 38
Posted By theDBguy
Re: Hello!

Hi Mike. Welcome to AWF!
Forum: Tables Today, 11:50 AM
Replies: 16
Views: 122
Posted By theDBguy
Re: Help with Spare Parts Database - I'm New!

Hi. I would probably do it more like this (incomplete).


https://access-programmers.co.uk/forums/attachment.php?attachmentid=77429&stc=1&d=1573674590
Forum: Forms Today, 10:54 AM
Replies: 3
Views: 43
Posted By theDBguy
Re: Hiding checkboxes depending on the value of another field.

Hi. There was a discussion on this same topic recently. Check out the similar threads links below. Otherwise, I'll see if I can find a link for you.


Edit: This is the one I was thinking about...
Forum: Introduce Yourself Today, 10:42 AM
Replies: 2
Views: 28
Posted By theDBguy
Re: Hello

Hi. Welcome to AWF!
Forum: Modules & VBA Today, 10:40 AM
Replies: 12
Views: 158
Posted By theDBguy
Re: VBA Help

Try this:
DateDiff("yyyy",[DOB],[VisitDate])+(Format([DOB],"mmdd")>=Format([VisitDate],"mmdd"))
Forum: Tables Today, 10:36 AM
Replies: 16
Views: 122
Posted By theDBguy
Re: Help with Spare Parts Database - I'm New!

Hi. Here it is as an image for others' reference.


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


At first glance, the field CompanyName seems...
Forum: Forms Today, 10:11 AM
Replies: 8
Views: 87
Posted By theDBguy
Re: New to Access - difficulties with forms

Hi. Glad to hear you got it sorted out. Good luck with your project.
Forum: Forms Today, 10:10 AM
Replies: 6
Views: 89
Posted By theDBguy
Re: Scrollbar appears a record early

Congratulations! Glad to hear you got it sorted out. Good luck with your project.
Forum: Modules & VBA Today, 10:03 AM
Replies: 9
Views: 68
Posted By theDBguy
Forum: Tables Today, 09:46 AM
Replies: 16
Views: 122
Posted By theDBguy
Re: Help with Spare Parts Database - I'm New!

Hi. Good luck. Let us know how it goes...
Forum: Queries Today, 09:41 AM
Replies: 3
Views: 73
Posted By theDBguy
Re: Access error -query is corrupt

I actually saw this happen to someone's database yesterday. Thanks!
Forum: Modules & VBA Today, 09:40 AM
Replies: 9
Views: 68
Posted By theDBguy
Re: Copy Excel data to Access Form

Hi Gale. Just in case it helps, I just created the following function for you.
Public Function GetExcelData(FilePath As String, _
SheetName As String, CellName As String) As Variant...
Forum: Modules & VBA Today, 09:30 AM
Replies: 9
Views: 68
Posted By theDBguy
Re: Copy Excel data to Access Form

Hi Gale. Yes, everything will be controlled from within Access. So, the code will be in Access. The Excel file doesn't even have to be open to grab data from it. It just has to be accessible from...
Forum: General Today, 09:25 AM
Replies: 4
Views: 94
Posted By theDBguy
Re: Every Growing Database and Compact doesn't work

No "make-table" queries at all? Do you delete and append multiple data a lot?
Forum: Modules & VBA Today, 09:23 AM
Replies: 9
Views: 68
Posted By theDBguy
Re: Copy Excel data to Access Form

No. I am saying you can use Excel Automation to "grab" some data from an Excel file from within Access.


PS. You may have missed the link I added to my original response above.
Forum: Macros Today, 09:20 AM
Replies: 10
Views: 98
Posted By theDBguy
Re: Skip Append Query if 0 Rows

Hi. Based on that, this should work.
If DCount("*","QueryinAccess")>0 Then
Forum: Modules & VBA Today, 09:16 AM
Replies: 9
Views: 68
Posted By theDBguy
Re: Copy Excel data to Access Form

Hi Gale. Sounds like you might need to use some Excel Automation.


PS. Here's some light reading...
Forum: Forms Today, 09:09 AM
Replies: 8
Views: 87
Posted By theDBguy
Re: New to Access - difficulties with forms

Another option is to export your table structure to a new database and post a copy here, so we can take a look as well.
Forum: Tables Today, 09:08 AM
Replies: 16
Views: 122
Posted By theDBguy
Re: Help with Spare Parts Database - I'm New!

Okay. So, which field is the primary key for the Products table?
Forum: Tables Today, 08:52 AM
Replies: 16
Views: 122
Posted By theDBguy
Re: Help with Spare Parts Database - I'm New!

Hi. Can parts come from multiple vendors? For example PartA can come from Vendor1 or Vendor2? if so, you may need to split your product table into two (or three).
Forum: Introduce Yourself Today, 08:49 AM
Replies: 20
Views: 187
Posted By theDBguy
Re: Hello! I'm interested in databases purchase

Debería haber dicho, ¡buena suerte!
Forum: Theory and practice of database design Today, 08:45 AM
Replies: 1
Views: 28
Posted By theDBguy
Re: Every Growing Database Doesn't Compact or Repair

Duplicate post (https://access-programmers.co.uk/forums/showthread.php?t=307899).
Showing results 1 to 25 of 500

 
Forum Jump



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