Search results for query: *

I know that the norm is to display one record after another, but I am trying to find a way to split the report and have one record on the left and the next record in the database on the right....Can this be done.... I am using access 2k Thank you for your help in advance, TPowers

Hello everyone I am trying to assign ID numbers to certain records in my database and I have already run a query that tells me which records need these ID numbers and I have alread created the ID numbers in another table. Now I am trying to assign these ID numbers to the certain records, with...

Hello everyone I am have been trying to get this code to work for the longest time and I jus can not grab it. I have a form that has a sub form and and I have code that when you double click a field in the sub form another form opens and it is controled by a query that is looking for data from...

I am trying to save a record by running the vb code "DoCmd.GoToRecord , , acNewRec" and some how every time I run the code I get this error message that says "You can not use the GoToRecord action or method on an object in Design view, but I do not have any objects in design mode. Does anyone...

Hello everyone, I am trying to import a fixed width flate file and I was informed that the only way that I can do that is if I write a code in vb that will parse eaching line. Now since I am new at this I am unsure how to parse a flate file in vb. If anyone can help me that would be great...

The following code is giving me the same error IE: 2115 As stated in my above and first theard I do not have any beforeUpdate or validation rules set to the field that I want to add data to nore is this field connected to a table or query. can someone please tell me why this error is comming...

I am tring to use an after update event on a drop down menu and when I do this I am getting an error that reads "The macro or function that is set to the beforeupdate or validation rule property for this field is preventing Microsoft Access from saving the data in the field." Can...

I am tring to get the current count of records in a certain query. I have no clue on how to use the count option in VB. Can any one help me please. P.S. I am using Access 2000 Thank you in advance, TPowers

I am tring to change the controlsource for a control using vb but it is not working. The code that I am using is as follows: CountOfLoanNo.ControlSource = CountOfLoanNo I keep getting a this error in the control box during run time. #name. Why is this, and how can I fix it. Thank you in...

I have a form that a user will scroll in and look for a certian record. when the user finds the record that they are looking for I have them double click on the that record and a 2nd screen comes up. I need to be a able to take the data in the primary key field on the data sheet and plug in into...

I have a form with 2 date fields. I have the users entering in the data in the format of mm/dd/yy, but I need to convert the dates in to yyyymmdd so that the database can understand it. does anyone know how I would do this? Thank you in advance, TPowers P.S. I am using Access 2002

I have four radio buttons that I have set an after update event. This after update looks at what value the set of radio buttons ends up with. I do an if state that states if frameSelections = 1 then txtbox.text = "sjfksjflksjdf" else: if frameSelections = 2 then...

On click I am trying to run a query in hidden mode. Does any one know the code for this. I have looked at the macros, but nothing seems to work. Thank you in advanced, TPowers

Hello everyone, I have some code that allows the user to put data in one of three text boxs and then click a cmd button to get data back from the database, but what I am trying to do is allow the user to enter data into one of the fields and then press their enter button on their keyboard and...

I am trying to make several fields on my report ascend but I can not find where that option is in the design mode I know it is sitting right in front of my nose but I just can not see it. Can someone please help me? Thank you in advance, TPowers

I have a location field in my table, and in this field I need to pull out only the numeric section of the field. I was wondering if anyone could help me with the code? I have been trying to do this forever but I just can not get the query or code right. the numeric section of the location is...

I have a signle form database, and in this database I have went into the startup option of the database and had the database window not visible so that the end user can only see the form. However the access window it's self is still visible, is there a way to make that window not visible as...

I have a from that needs to get the record count in the navegation bar. Is there a way that I can pull that data into a field? Thank you in advance, TPowers

I have a form that only has unbound controls. On this form I have a button that will allow users to print are report that will display the data that is on the screen. The problem that I am having is that since the form is not bound to any table or query I do not know how to do this. Is there a...

I am trying to create a query with vb. the query will be pulling to dates like a between this date and this date. Does anyone know how to do that. thank you in advance, Tpowers