Search results

Turn off your On_Error statement and let us know where the error is actually happening.

Just to verify one thing...when you say combobox you actually mean a listbox, right? The reason I ask is because a combo can only have one value, so when you talk about multiple values...well, you know.

That wouldn't CC but instead send the email to somebody@ntlworld.com and the person whose email address is in the field. Using DoCmd.SendObject you get a To and an CC parameter. DoCmd.SendObject , , acFormatRTF, strEmailAddress, "somebody@ntlworld.com", , strSubject, strMessage

Welcome to Access, which is not Excel. Something about the way you describe this project/issue suggests that you are approaching table design in Access the same way you may set up an Excel spreadsheet. This is not the approach to take. There is no VLOOKUP() function in Access. There is domain...

Goes against some basic database design, though. You'd have been better just using queries to select the relevant company info from your main table. Okay. Here's a quick overview. Tables store data. They can have fields and rows. Queries question or manipulate the data. You can get SELECT...

Ah, you were passing the control name. Got it! As, I see, have you now.

Ah, hold on. Sounds like you have a variable and a control both called vField. Does using ByVal in your sub help? Private Sub form_open_data(ByVal vField, ByVal vFile) (To remove ambiguity, this is why it's a good practice to use prefixes for controls, variables, everything. tblTables...

Not sure I quite get what you're asiking here. The contents of the variable is all that it is. It's an empty box that you put a value or an object into.

Would have thought Split() worked purely in VBA. Certainly if I try to replicate it I get the same error as yourself. However, a search of the form highlights othe threads where use of the Split() function in this way has been offered as a solution. Maybe it worked in prior versions. Anyway...

Basically, your database will grow in size every time it's used. If you delete a record (or a huge table!) then you don't automatically get the space back. It holds it. Therefore, you need to Compact the database, and it will reclaim all the space.

Either Regex, which I'm terrible at to check if the string meets particular format... ...or use combinations of InStr() and Mid() to oick out the years from within brackets. a = InStr(1, MyString, "(") b = InStr(1, MYString ")") If b-a = 5 then you have two years to get out. Use Mid() to...

What's the next bit like?

Also, as an aside: Dim sqlStr, insertSQL, arrayVal As String That's making two Variants and one String. Dim sqStr As String, insertSQL As String, arrayVal As String

For i = LBound(TestArray()) To UBound(TestArray())

Try: With xlWSh.Range(Chr(64 + intColumn) & "3:" & Chr(64 + intColumn + 1) & "3") .MergeCells = True .HorizontalAlignment = xlCenter End With Get a result?

You did. I just never read it properly. Still, can certainly loop through a Split() array.

Could you work through each record, perhaps using the Split() function to put the data in arrays. Then some more code to check if it meets a number of criteria and, if so, insert a new record with that data into your new table. Based on your example, the lower bound of the array (0 in this...

Between 24600 And 24999)) Between 23000 And 24519)) (Formula < 23000) OR (Formula Between 24520 And 24599) OR (Formula >= 25000)

Create a new field in your query; IIf(IsNumeric([YourSKUField]),CLng([YourSKUField]),0) Then put your Between ... And ... criteria on this new field.

Get External Data -> Access and then pick that you want to link to a table. Then pick the table in the other database.