Search results

I'd like to know if its possible to copy an entire record within the same table. ie in table1 i have a record with 10 fields - the first being the primary key - an ID field i'd like to copy that record and create a NEW record with all the same information. I thought it would be easy to do...

I also put this under the Query Forum, but i thought i would try a module as well. Is it possible to write a query or code that can determine if a list of records are in sequential order? ie 1,2,3,4 what i want to do is find out of say 1000 records if there is are some free sequential #s. the...

Is it possible to write a query that can determine if a list of records are in sequential order? ie 1,2,3,4 what i want to do is find out of say 1000 records if there is are some free sequential #s. the sequential #s are then given to some other records for processing. also the user selects...

hi, i've done some searching and i can't find anything that answers my question so i apologize if i'm regurgating anything... i'd like to be able to validate users onto an access97 db through their network domain accounts. that way they only have to remember one password to log on and to log...

hey there, i have a dB that i want to close programmatically. i know how to do this with the docmd.quit command. and i've bin able to setup a form with a timer which checks the value of a field in a table - when the times match the system shuts down fine. my only beef so far is on some of...

Hi, I'm trying to create a report which when run loads a filter which is passed in through the docmd.openreport command. it works fine if the filter has only one criteria. IE Date Between ## and ## BUT if i enlarge the filter to contain two criterias IE Date Between ## and ## AND Date2...

Hey, for whatever reason the find unmatched wizard will not work for me when trying to setup a query. i have two tables - one table gets updated all the time so i have to use another table with all the part#s in it. when the 1st table gets updated i want to search for part#s which are not in...

Hi there, I have a report which lists a lot of redundant information. In order to have all the information on the same line I cannot use any grouping with different headers, in the report, but I also don't want to show that redundant information. So I wrote some code in the detail section of...

hi there, i have been trying to create a query that will give me a running total for purchase order quantities. i am using two tables. one which has the item on the purchase order and one table which has the recieve info for that item. each item can be received multiple times thus multiple...

Would anyone know why the code for error handling does not work?? ie: Private Sub Command1() On Error GoTo Err_Command1 DO CODE Exit_Command1: End Sub Err_Command1: Msgbox err.description Resume Exit_Command1 End Sub I've used this code before and it worked fine but now it will not...

Hey there, does anyone know how the tabcontrol onclick event works?? i've set up some code in the even but when i click the tab i want the code doesnt run - i dont even think its looking at the code at all. - Topher

Hi! Im using the Treeview ActiveX control in order to display a hierarchy scheme. Im using a loop to go thru a record set and display the part descriptions. it works fine until i get to a certain point and i get a "Index Out of Bounds" runtime error 36500 i think its because i have too many...

good day all, im hoping someone knows how to manipulate the properties on forms thru VBA code?? the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms. If...

good day all, im hoping someone knows how to manipulate the properties on forms thru VBA code?? the thing i want to do is change a few properties on ALL the forms in my DB - theres about 20 or so. i've bin able to figure out the code using collections to list all the names of the forms. If...

Hey Access PPLs! I got a whopper of a problem. I need to cycle thru all my tables in order to find a field name and then change data in that field name. I was hoping this would be easier than going thru all the tables manually, finding the field and putting it in a big list of SQL Code. Is...

Oky Doky heres me problem. i'm trying to list the results from 4 different queries in 1 list box. the results show up depending on what the user selects. that works find and dandy, BUT what i want to do is make some of the columns smaller and some larger - depending on the result chosen. i...

I hope someone can help. I'm trying to create a report that will force a new page after the date has changed. So say i have 5 records with 5 different dates. date1 with record1, 2, 3, 4, 5 date2 with record1, 2, 3, 4, 5 etc... how can i create a report that would force a new page on each...

I'd like to know if its possible and if so, how? to open word thru access and have word open a document which is referenced in a table in access. IE TABLE1 has a field with "C:\readme.doc" in it i have a button which will open word but how can i get word to open that readme.doc file...

Hi there, does anyone know hot use the Chr function to format strings?? i've used it just like the help says and it wont work - i need to use a carrige return chr(13) - but every time i use it i get an error stating that the project or library cannot be found - yet if i check the references its...

Hi there, i have 4 pages on a tab control and one command button - i would like that command button to print the report that coressponds to each of the tabs....therefore i need to check which tab is selected before i can print the report....is there anyways to find out which control tab is...