Search results

I have code in the Form_Current that is apparently running when I close the database. Is there anyway to stop this code from running if that database is closing? Thanks in advance for any help.

I have a subreport which is linked to a query. In the detail section of the subreport I have the straight value from the query. I added the subreport to my main report and set the source of my text box on the main report to the text box on the subreport. It works great on my computer and on...

I created a crosstab query that I'm using to dynamically create a form. I know how to create a total in a crosstab query but it creates it before it creates the columns. I need the total column to show at the end of the columns. Does anyone know how to do this?

I am having problems with reports that have subreports. If there is lots of data on my reports and the subreport ends up being at the end of the page the text sometimes gets cut in half. I have the text box set to Can Grow Yes and Can Shrink Yes. I also have the grouping in the subreport set...

I have two subreports on one report. One subreport shows hours worked on-site for a month period broken down by week. The other subreport shows hours worked in-house for a month period broken down by week. On the main report I want to show total hours worked broken down by week. I tried...

I have a text box in the detail section Text1 with the running sum set to Over Group and a textbox in a group footer Text2 set to Text1. This works fine on all the computers in our office except one computer. I checked Text1 and the running sum is working fine but for some reason on this one...

I'm going to try and explain this the best way I can so please bear with me if it doen't make total sense. I have two tables tblSales (is used when am employee makes a sale) employee date tier level tblTierLevels (shows all the different tier levels and the pay amounts) tier level pay amount...

Yesterday when I was working on a report with subforms when I went to save the report on exit I received the message "file sharing lock count exceeded. increase maxlocksperfile registry entry". I clicked OK then I received the error "No Current Record". Once I clicked OK on that error all my...

I'm not sure if this is the right place to place this thread but what I need to do is create a report with grouping. The fields are: Employee Task Description Clients The form is set up with drop down boxes for task and description and the clients is a multiselect listbox. This form was...

I have a spreadsheet that I'm importing into a table using TransferSpreadsheet. We are recieving this spreadsheet from a client and do not want all the fields imported into our system and I want to make this as fast and user friendly as possible. I know to set the range argument you use...

I have a listbox set up on my form which lists all of our employees. I also added a "Select All", "Select All Canada" at the top. Is there a way to check which item was selected as soon as the user selects an item. What I want to do is as soon as the user selects "Select All Canada" I want...

I have two identical tables in my database and I need to do a sum of certain records from both tables so I created a union query to pull the information from the two tables. Now I need to do a sum of the records from the union query. I know that I can create a seperate query to look at the...

I was wondering if Access keeps track of any changes made to a database. I'm having problems with a database that someone before me created. Some how records are magically disappearing from tables and a field in certain records in another table are magically being changed. So I'm wondering if...

I was just curious if it's possible to take information typed in a form and paste it into HTML. We need to data-enter customer info into our database but we also need to enter info into a form on web page. The web page is not ours so I can't set the page up to send the info to access. Is this...

I have a database setup to track daily tasks. When you open the database a login form automatically opens with a drop down box of names and a textbox for passwords. When one of my users opens the database he gets the error "Method 'Recordset' of object '_form_sfrmLogin' failed. Error...

I have a customers form and in the form header I have a frame with 2 option buttons. I want the user to choose to either add a new record or search for a specified record. The search works fine but the DoCmd.GoToRecord , , acNewRec doesn't work. I get the error "You can't go to specified...

I have a very large report with subreports based on quite a few linked tables. The report opens just fine but when I go to print the report I get the error "Cannot open any more databases" and one of the subreports doesn't print. Does anyone know why this is happening or how to fix it? It...

Out of no where VB has some how become corrupt in one of my databases. When you try to open a form or report that has VBA code written I receive an error stating the database is corrupt and to do a compact and repair. I tried this and it didn't help. I also get the error Microsoft is unable...

I have a function and the word Beep in my on my form_timer event. The function works but my computer doesn't Beep. Does anyone have any idea why. Is there a setting I need to change?

I was wondering if anyone knows a way to help make reports run faster. I am runing a report that uses a very complex query with linked tables. When I am in design view I get a 30 second lag. When I go to run, save, or open in design view it takes at least 2 minutes to open. I have 512 mb...