Search results for query: *

I have code like this in a module - Option Explicit Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _ ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _...

I have code like this in a module - Option Explicit Private Declare Function ShellExecute Lib "shell32.dll" Alias "ShellExecuteA" ( _ ByVal hwnd As Long, _ ByVal lpOperation As String, _ ByVal lpFile As String, _...

Having some trouble using a checkbox. Tried both Form Field and Control Tool checkboxes Code that is giving me trouble is Case 1 'Amended If Amended.Value = vbChecked Then MyStr = MyStr & "Y" Else MyStr = MyStr & "N" End...

I have a form. There is a check box on the form. If we want a one page report printed for this item we click on the check box. We go thru all of the current items and check this if we want to print this one page report (always the same report but different items). I now want to create a...

I set up a macro a couple of years ago. We have to print out acct forms once per year and mail them out. This has worked fine for a couple of years. Now this year (not changing any code) it prints the first one and then gets hung up until excel completely crashes. If I step through the code...

I have a file that I need to download daily. I save it in the same spot everyday. It saves it as S:\ERETR\Downloads\00 Year-to-date.xml.zip\00 Year-to-date.xml First I check to see if the process file exists? if so kill it so I can recreate it from the new download Dim FSO Dim file as String...

I am cleaning up some data in an excel file. STUCK! Please help. I know I am missing something goofey! This column is holding a dimension. The only problem is some dimensions are reports 5' some are reported 60" and some are both 5'2". So I have the Foot problem taken care of. I want to...

This is my code. If I print only one at a time I'm Fine. If I print a range from 1 to 10 and step through the code it works fine. If I print a range 1 to 10 and just let the code run, excel crashes. I have to print 2200 of these. i don't want to have to step through all of them. This worked...

I have a form that gathers Parameters for a query. I press a Search Button and I have code that sets my Form Visible = false and Shows the Query If Someone Click on the X to close the Query I want the Form to be visible again. How do I do that??? is it Possible? Where do I program this? TIA

I have a Search form that gathers Parameters to pass to a query. When the Search button is clicked it opens up a query with the Values from the Form. Below is what I have in the Criteria for field (YrBuilt) in the Query. I have tested and tested and I keep getting a blank query. Like...

I have a summary Query that tells how many records are pending (Field Pending = true) Query works fine I have a Summary form where I want to put You have ______ Contracts Pending Where the blank is the number from the query.. I did a Bounded Text Box with a source of =ToProcess![Count Of...

I am working with a table with about 50 fields. Many of these fields are Text fields... And All Text Fields have a Size of 255. I want to shrink that down to about 25 or 30. Is there are way to do this at once with out doing CurrentDb.Execute "ALTER TABLE test ALTER COLUMN Last Text(25)"...

I have a table with several row where Dim SQL1 As String SQL1 = " DELETE * From cust Where [contract] = ??? " DoCmd.RunSQL SQL1 Contract has a 1, 2 or nothing in it. i want to keep all the 1's and 2's but delete out the ones with nothing. I have tried NULL I have try "" and '' and <> 1 but...

Hi All, I am writing an update query to update a text field. The field looks like 000XXXXXXXXX. Not all fields have a 000 in the front. I want to delete only the 000 and leave the rest of the data. Here is what I have. Dim SQL1 As String SQL1 = "UPDATE [customers] SET [acct] = Replace...

Here is sample data Test Table 1 ID NUM DESC 1 1 Hi 1 2 Every 1 3 One 2 1 See 2 2 You 3 1 Welcome 4 1 Thank 4 2 You I want to make this table become...

OK i have no Idea what I did that could have broke this. It worked fine Yesterday Morning. (Unfortunately my last backup and I have done to much work to go back to the backup and move ahead) When I open my Form the top part of the form is the Main Client. The bottom part of the screen is 6...

I have a form that is Tabular. The First Field is a Date Field. The Second Field is a Comment/Memo Field. This is to track an acct when ever someone has contact with this client. I have the form opening with Date in DESC order. So the Newest/last contact info is at the top. The Default...

i have a sub form that tracks all changes made to the database. It shows the old value and the new values as well as which form and name of which field where changed and who made the changes. I have several check boxes that show up as -1 old value and 0 new value. I know what these values...

OK, What am I doing wrong? I have a form with a Tabbed Sub Form. When I click on one of the tabs (history) it should open up the sub form and show all changes made to this project in DESC order of date. I have set the Sub Form Order By Property to tblHist.dtChg DESC Open the form, still in...

OK, I got my other queries to work (thanks from help here!) I now have to do another update query but this time the Primary key is two fields in both TableA and TableB How do you code that? This is what I have Dim SQL1 As String SQL1 = "Update A_Addr" & " RIGHT JOIN csm_addr " & _...