Search results for query: *

I need to write a module to compare fields in a table. For example I have acct_num and acct_nummi, I need to check to see if the value in acct_num = acct_nummi and if not i need to update an other field with the with and Y for yes or N for no. The problem is I need this function to be...

I have a report with a lot of text boxes. I need to check to see if the value of the text box is < 0 (- number)and if so print that line, if the value is >= 0 skip it and dont print it. Thank for any help.

I have a table with 120 fields. I am running this small function just to print out the name of each field. When it gets to the 57 one it stops and give me an error "run time error 3021" no current record" when I restart the function at 58 it goes to record 114. Its only doing 57 records at a...

I am importing excel spreadsheets into my db. I was wonder if there is a way to reorder the fields in the table to be asc order. I don't need the data in asc order just the fields(columns) in this order so it will display nice for the use on a datasheet form. I am createing the form on the...

I have a weird problem. I am importing in data from excel spreadsheets. and I want to be able to display the data to the use in a datasheet view form, my problem is the struct of that data changes from one spreadsheet to another. So is there a way to create a form on the fly and the currect...

How do you turn on a custom toolbar from code. thanks

I am try to trap to make sure the user filled in all the fields that are req. So I did an check on the next button to do a query on the table to check to see if there is any null values. It looks like it works the frist time but then after it dosent Can someone look at my code and see if I...

I have a form Ineed to open with a filter. I can get it to work as long as the filter value is not null. When the filter val is null i get all the records. I should only get the records where the status is null. I know I am doing somethingn dumb here. here is my code on opening the form...

I have a text box on a form its control source is a memo field from my table. I need the user to add info into the text box, but I don't want them to be able to delete any of the data that is there already. Thanks for the help. G

I am using access 2000 and this is an ADP project. Does anyone see anything wrong with the function. the first if works find, its finds the store proc and runs it. When I get into the case section I get error 2580 it cant find the store proc. I can see all 3 proc in the store proc tab in. I...

How do you call a store proc from a form. Thanks Gary

I have to export this data from a query onto an csv file for a client. The data in each feild has to be the exact length. so for the first field: id as to be 33. in my table the feild length is only 10. so when I created the export to csv comman del I cant get the feild to be 33. I kn...

I open a form with a where clause. it works fine, I use the same form to view/edit the data. I also let the use to add new records on the same form.But when I go and try to save the new record I get an runtime error 30014. Thanks for any help

I have a form with 2 list box on them, when I click on a name in list box 1 I write that infor to a tmp file and I want the name to show up in the 2 list box. I set the rowsource of the 2 list box to be the tmp file. The info is being written to the tmp file but it will not show up in the 2...

It there a way to search a database and identify all queries which are not used by any database object? Thank you

I have to create an new/add a field to a table in vba. I need to set one field to be an boolaen type. I get that to work but I also have to be able to set the format of the feild to be "yes/no". I am able to set the defaultvalue prop but I can not get to the format prop. THANK YOU here...

I am trying to import a excel spreadsheet that has many sheets in it. I want to put each sheet into a diff table. I am running this from vba code. It imports the first sheet ok into a new table but the second sheet it does not do it. And the 2 table is filled with the same data from the first...

I want to be able to loop thru an excel workbook that has 20 sheets init and be able to delete the first row in each sheet. Here is the code I have. it deletes all the rows(the first sheet only has 2 rows)in the first sheet. Thanks Set xlapp = GetObject(, "Excel.Application")...

I have to do some high end math in access. Does Acces have the power() function like in excel? I need to be able to a take number and raise it to the power. also does access have cuberoot functions. I can not find it. Thanks

I am trying to use an IIF in a query. I have a form where the use enters in date ranges. date1 and date2 I want to do a check in the query to see if the first date was null and if so run the query without any date range in the criteria. the qry worked find before I add in the date ranger...