Search results

Thanks! But honestly I had to do some Googling to remind myself why it's "bad"! I'm stubborn in my own ways, for no particular reason (ie., I'll indent the way I want, dammit! :D) but as you pointed out, every rule has an exception, and I figure that, at the end of the day, the right way to do...

If you're importing data into Access you need to make sure that not only the destination table is closed, but also that any other db objects (queries/forms/reports/other tables) that are in any way linked to the destination table are also closed. Try closing everything except the Visual Basic...

It made me chuckle that 100 people have read your post but nobody will tell you how to add a calculated field... on the other had, they might have your best interests in mind! Now, I might get shunned for telling you how:eek:, but I'll try to make up for it by sharing my understanding of why...

I think you want to export the records from Access to Excel based on dates on an Access Form? Here are a couple options: You could create a (permanent) query, for example called "qryDateRange" with and in SQL View paste: SELECT * FROM myTable WHERE myTable.myDate BETWEEN...

"We're all here 'cause we're not all there"...? Welcome, Nick!

It's Excel that's limited to column XFD, not the code. I'm curious, what exactly do you need to accomplish with character sequences?

Attached is a fairly basic example of Combo Box / List Box data manipulation with multiple tables using VBA.

From your description & code, it's tough to determine exactly what you're trying to accomplish. I find that when I'm having an issue with a complicated part of a database, it helps to create a new (temporary) database, kind of a simplified "mini reproduction", get that working, and add to it...

Sub ExportAllTables() 'export all non-system tables to Excel file in same folder as DB '(creates an Excel file if it doesn't already exist) Dim tdf As TableDef, xlsFileName As String, count As Integer xlsFileName = CurrentProject.Path & "\" & _ Left(Application.CurrentProject.Name, _...

Here's another one, similar idea, originally spawned from the formula to convert from Red/Green/Blue (0-255) values to Access-friendly decimal (Long) values: RGB = (R * 16 ^ 0) + (G * 16 ^ 2) + (B * 16 ^ 4) and vice versa. However I soon realized that it's not terribly efficient; the example...

Everyone has to start learning somehow! :cool: Can you give an example of the tables you're working with (or want to be working with), and an example of your desired query output? Did you want the ID to repeat, or you want to avoid it? It's easier to picture what you're dealing with, with...

If I understand correctly... In tblClientGender, is ClientID set to AutoNumber? It shouldn't be. The ID is created in the other table. tblClient ClientID AutoNumber (primary key, long integer, increment) ClientName Short Text tblClientGender ClientID Number (primary...

At least she tried to put him out! Hmmm, so she's single now huh? <3

Very nice :p

Re: Quicken Report Checks/Cheques Only Depending on which option you don't have, you may be able to display it in Register Preferences. Also here is a workaround or two to print a report of only checks/cheques.

Are you getting an error?

Check out this and this.

The ribbon's not showing in that picture, I think you mean the menu bar and title bar? This might help: https://access-programmers.co.uk//forums/showthread.php?t=293584 Also: DoCmd.ShowToolbar "Menu Bar", acToolbarNo

The Next Without For error is because the If statement If FileFound = "" Then is missing it's End If. VBA confuses it's Next's and End's and Loop's sometimes when trying to convey errors like this... :rolleyes:

I have some experience with it, currently mainly for testing, to send SMS via email when something's going wrong.