Search results

Hello, I have MS Access 2010. I cant remove password because when I open in exclusive mode, file, info, there is no decrypt password option. Any suggestions?

I have a truly split db. There are 7 users that have fe copies on their desktops. I have one user that gets this error message on one of the forms. The form is completly un-usable but only on one fe. All other fe users have no problems. Error message: Microsoft Access cant add, rename, or...

I am getting this error in a db. There are 7 fe users and only one user recieves this error. Any thoughts or suggestions on how to fix? Microsoft Access cant add, rename, or delete the control (s) you requested. Thanks

After installing some microsoft updates I am now getting this error when opening the db. Cannot open database....It may not be a database that your application recognizes, or the file may be corrupt. any thoughts on what could have happened?

I am a newbie and need help removing a password. This link explains my exact problem. I have entered and changed the code as stated however it does nothing...Any help??? Thanks http://vajentic.blogspot.com/2008/08/removing-password-that-was-created-in.html Here is my version: Public Sub...

Hello, I do not have a split db. I am prompted to enter my password when the db opens which is fine. However, when I close the db it prompts me to enter a password (not normal) and when I enter it it says invalid password. Also, when I try to change my password it says invalid password and when...

I need assistance exporting a report to an excel template. I am not too familiar with vba code but I know that this is the best way to accomplish this. The name of the excel sheet is "csl" The location of the excel file is C:\users\lowana.hernandez The export should begin in range A6 the name...

Good morning, I am trying to convert from Access 2007 to 2010 and I am getting this error "Compile Error User-defined type not defined. Please help Thanks! Private Sub cmdAppend_Click() Dim cnn1 As ADODB.Connection Set cnn1 = CurrentProject.Connection 'set up the recordset Dim myRSQuotes As...

Hello, I have mulitple dbs that are exactly the same in design that I need to combine into one db. The problem that I am having is that the primary keys are autonumbers and I get errors when trying to copy and paste the data into the tables. Is there an easy way to combine/merge all the tables...

:confused: I am wondering if you can get help with vba code that will change criteria in a query qryComparisionSheet by discipline then open rptComparisionSheet when it is selected from a drop down menu...let me know if i make sense.. thank u in advance a sample db is attached password LOCK

I have attached a sample db. What I am trying to do is create code that will change the criteria in the qrycomparisionsheet for each of the 121 disciples in the tblDisciplines. The reason this needs to happen is that I need to have reports for each discipline rptComparisionSheet. A drop down...

Is there a way to create a query that will put the winning bid next to the competition bid for side by side comparision? I have attached a sample db for reference. the qry with the information that i need to compare is qryWinningBidReport

When I export a query into excel the yes/no fields that I have read as true /false instead of yes/no. Is it possible to get to read yes/no after being exported into excel? Also when I export currency into excel it goes out to two decimals places even tho the default setting in acces is at 0...

The table that I need to make a query for is a quote table for subcontractors winning and competition quotes. I need to make a query that pulls the "Winning Bid" and "Winning Bid 2" from each row. The problem that I am having is that since there are 8 fields (Quote status 1-8)for the "Winning...

Is there a way to have a macro that builds a query? I use the same query over and over again. (only changing the criteria) I do not want to have to repeatedly build the same query using the query design. Any help would be great. Thank you

Below is the code that needs to be changed to open the form in the datasheet view: I just don't know where to change the code. Can anyone help and advise how to find where to change the code? DoCmd.OpenForm stDocName, acNormal, , , , acDialog CHANGE TO::confused: DoCmd.OpenForm stDocName...

From the switchboard I can not get forms to open in the datasheet view. I have it set as the default view but it still opens in the form view. Does anyone know the code? and if so, where do I put the code. Thank you :confused:

Can you let me know what is wrong with my formula.... I get the answer of $0. Thank you Nz([Total Hours],0)*Nz([tbl_BAEComp]![Rate],0)+Nz([MATERIAL VALUE],0)*Nz([tbl_BAEComp]![G&A Rate],0)*Nz([tbl_BAEComp]![Award/Inc Fee],0)+Nz([SUB QUOTES],0)*Nz([tbl_BAEComp]![G&A...

I can't get this calculation to total. Please let me know if I have it entered incorrectly. Thank You! Total: Round(([Total Hours]*48.55)+([TOTAL MATERIAL VALUE]*6.4)*(11.23+[SUB QUOTES])*(6.4*11.23),0)

Hi, Im Lowana I live in beautiful San Diego. I just created my first database and love ACCESS :)