Search results

Hi All: long time no ask! Running MS Access 2003. I'm trying to run a couple of queries using code and it works fine but when it runs you can actually see the query window open and close really fast. How can I run it without showing the query window? This is my simple code...

Hi All: running MS Access 2003. I have two forms: a login form and form B. The login form has two fields: User and Password. When the user logs in, I hide the login form and open another form. How can I refer to the login name on the login form from another form? In other words, I need...

Hi All: long time no thread! Running Access 2003. I have a report with group headings that starts each group on a new page and pages are numbered. How can I create a table of contents showing group heading and page number for each group? thanks!

Hello World: I have two tables, one called Assets and the other table called Job Sites. the Assets table has several fields AssetID - autonumber plus others the Job Sites table has two fields JobSiteID - autonumber JobSite - text (with about 22 names in it) the I add the JobSite to the...

Hi All: I have tab controlled form as a sub form in another form. Is it possible to create a radio button list on the form so when I click on one it changes the tab control subform to that page? Any ideas, hints, comments, remarks or observations are welcome. :D

Hi All I'm getting an "Argument not optional" error on this piece of code. The qry itself is a make table qry and I need to bypass the prompts. Any ideas why? thanks DoCmd.SetWarnings = False DoCmd.OpenQuery "qryJobInfoMkTblSpectrum", acNormal, acEdit DoCmd.Close acQuery...

Hi All: given a table with, let's say, Job Numbers that start with a letter (such as RES2345) or just plain numbers (such as 253180001 or 9817) how can I set the criteria in the query to just give me jobs that start with a number? I first trimmed the field to eliminate blank characters and...

Hi All: I downloaded the sample.mdb that itasev posted on the Sample Databases and I'm having problems implementing it on my db. I have looked at the properties of the labels and the images and the vb code but I can't make it work outside of his form. I can't even add new menu items that...

Hi: I'm trying to implement the security found @ http://www.databasedev.co.uk/disable_shift_bypass.html but it does not work. The SAD part is that I implemented it on a 2000 db with ULS and it works like a charm! I've tried to replicate it on other db's but it does not work. Any ideas? The...

Double Prompt on Export to File Hi All: Using Access 2003. I have a simple macro to export the contents of a form to Excel. It works but I am prompted twice to enter the file name. This is how the macro looks like: Action: OutputTo Object Type: Form Object Name: frmInventoryReport...

Hi All: Using Access 203. I have a form and a subform tied up by the PurchseOrder field. The subform shows the items included in the PO but for any PO with more than ONE item, it shows the record as time times as there are item in the PO. In other words, if I have one PO with 1 item, it...

Hi All: running Access 2003. I have a form called Orders and a subform in it called Order Details. In the Order Details subform there is a yes\no field for Received items. THE FILTER DOES NOT WORK. IT'S LIKE IS NOT EVEN THERE. I have an unbound box and in the "On Change" Event I have the...

Hi folks: running Access 2003. I'm trying to accomplish the following: make a hyperlink visible if a control in the form equals to a specific value (5559). I have several records and I cycle through them using the built in Record Selector buttons. This is how I'm attempting to do it...

Hi folks: long time to no post! Using Access 2003. I have a form with 28 cmd buttons running each a different query. Each qry gives only one result (Top N of 1). I'm thinking of writting an if statement that would pass the qry result to a text box on the form regardless of which cmd button...

Hi All: using Access 2000/2003. I had a db in 2000 running a make table qry using the Autoexec. I had the Options set to not prompt for anything and it worked fine. I just converted to 2003 and even though the Options still show nothing selected (meaning it won't prompt), it does prompt me...

Hi All: is there a way or a tool out there that would tell me which forms are using a given query, short of opening each one? thanks :rolleyes:

Hi: Using MS Access 2000. Maybe I've been looking at the monitor for too long but... I need to have a query return data based on a date field or return all dates greater than 1/1/2001 if left blank. criteria: [Enter date - mm/dd] Or >#1/1/2001# When I leave it blank it gives me all dates...

Hi All: Running Access 2000. I searched the post but could not find anything that would help me. I have a continuous form and I need to show a total at the bottom of the page as the new records are added. I used the =Sum([field.name.here]) but it errors out. It works great on the reports...

hello World! Running Access 2000. I have a form with one text box in it. How can I select all the text in the txt box when the form opens and when I move to next record? thanks you

Good morning you all Access Elders: running Access 2000. I have a form with the following code (I found somewhere in the forum and modified it to fit my needs) in the BeforeUpdate event of a form On Error GoTo Err If Me.VeroDivisions_ID = "" Or IsNull(Me.VeroDivisions_ID) = True Then...