Search results

In the debugger the following line generates the error: Set rs = db.OpenRecordset(str, dbOpenSnapshot) I added the spaces as suggested and I like MSAccessRookie's idea of using in vs. or. Thanks for your help guys. I'll make sure and add positive reputation for you both. B

I should add that I determine field1 and crit1 as from textboxes on a form. Dim AccountingPeriod As String Dim FIELD1 As String Dim crit1 As String FIELD1 = Me.field crit1 = Me.OrgDetail

I have the following code that generates the Run Time Error 3061 - too few parameters - Expected 1. Dim db As DAO.Database Dim rs As DAO.Recordset Select Case UCase(Me.AccountingPeriod) Case "Q1" AccountingPeriod = "[Indorders].[Accounting Period]='200801' OR [Indorders].[Accounting...

I figured it out using another thread. Thanks to Wazz. http://www.access-programmers.co.uk/forums/showthread.php?t=131021 Brennan

Hello all, I have some dependant combos - when you select value in the first, it filters the second for the appropriate values. When I open the form with these combos, the default to null. Is there a way to have them automatically default to the first line on open, and have the second...

Alright, this one has me stumped. I have the following code. Me.Orders = DSum("['" & AccountingPeriod & "']", "PLMaster", "[Type] = 'Orders PS' And [Area] = '" & AreaDetail & "' And [PLtype] = 'Actual'") It worked for the very first value of AccountingPeriod, which is 200801, but it doesn't...

Hello all, Is there a criteria that I can use to strip out all text value and just return numeric values? For Example: If this were the value of a field "bstice50", is there a criteria to return just the 50. I can't use left and right functions because the numbers are located within...

Hi all, If there is a better way of doing this let me know. This is what I have so far and I need a bit of guidance to see if I can do this. I have a cross tab query that displays the value of an order over time (accounting periods). I want to see if the order value changes over time and...

Awesome - thanks. I'd give you more reputation, but I recently gave you some for help you have already given me and the system won't let me. Thanks again. B

HI all, I have a form with two tabs. Depending on which tab is open, I would like to print out a report with that information displayed on the form. I have both reports built, but I need to know how I can tell with VBA that a particular tab is displayed and the other behind it. Thanks...

Also - is there a way to get rid of the lines that frame the tab control? I would like for it to blend into the overall page? Thanks again. Brennan

Hi all, I have a tab control and the two tabs that I use are in the top left. It would be great for the look and feel of the form if I could change those tabs to be at the top right. Is there a way to do that? Thanks in advance. Brennan

Hello all, I have a DB that relies on three master tables. I import these master tables from CSV files that I save on a network on a monthly basis. My users would like to know when I have updated or imported this tables to my database. During the import process is there a way with VB to...

Thanks Alisa for the quick reply. I usually use the toolbar command but I wanted to see if I could automate that with backup, cleanup etc. I typed in the code you suggested, but I am not sure what else to add. The name of my Db is Backend. I get an Arguement not Optional error when I run...

I have a DB that only I use. Its gets big in terms of size very quickly. I would like to build some code that will allow me to run the "Compact and Repair" toolbar option as needed. I use Access 2003. What should this code look like? Thanks in advance. Brennan

I have a textbox that I use for a password. The problem is that it displays the text values in the input field. I would like it to display a "*" for each character input into the box. Is there a way to do this? Thanks Brennan

I am creating a macro and I am trying to get the macro to import a table from a parent DB to a local one. I know that someone will suggest linking, but my users don't usually have access to the network where the parent Db resides, so I have to have them import summarized tables. I know that...

Hello all, I am relatively new to access and I am building my largest DB yet. I was able to reduce the total size of the DB to about 10MB. When I put this in a network drive for others to access the speed of the database decreases dramatically. When I have the DB on my desktop, it flies...

I use excel automation to export data from access to excel. Often the numbers will come across as text and I use the little green arrow in the top left to convert the number value to text. What is the VBA code which would do the same thing. I have tried using the code to change the format to...

I apologize for the spelling. I actually did spell "with" correctly in the code, but I just typed "with" because it was easier. Thanks for the advice on the on the excel object reference. I added that and your code worked just fine. Thank you!