Access 2003, calculating dates
I have a database and I need the following to calculate based off a date field. My problem is that regardless if the date entered in that field is the beginning, middle, or end of month, I need another field that will produce a due date, which has to be the end of that month, [...]
Answer Question
| April 13, 2009 10:27 PM
Access 2003, calculating dates
I have a database and I need the following to calculate based off a date field. My problem is that regardless if the date entered in that field is the beginning, middle, or end of month, I need another field that will produce a due date, which has to be the end of that month, [...]
Answer Question
| April 13, 2009 10:27 PM
Access 2003, calculating dates
Microsoft Access Date
Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() ‘Sets the Date From and Date To text boxes ‘to Today’s Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today’s date into my From and To Date fields. The problem is I have these From and To [...]
Answer Question
| January 2, 2012 6:29 PM
Access 2003, Access Functions, Microsoft Access
Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() ‘Sets the Date From and Date To text boxes ‘to Today’s Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today’s date into my From and To Date fields. The problem is I have these From and To [...]
Answer Question
| January 2, 2012 6:29 PM
Access 2003, Access Functions, Microsoft Access
Access 2003 using VBA
I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have [...]
Answer Question
| April 3, 2009 2:10 PM
Access 2003, Microsoft Access, RDBMS, VBA
I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have [...]
Answer Question
| April 3, 2009 2:10 PM
Access 2003, Microsoft Access, RDBMS, VBA
DoCmd.OpenReport not working right with WHERE clause
I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I’m baffled that it doesn’t work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As String = “Fund Number 2″ [...]
Answer Question
| March 18, 2011 10:20 PM
Access 2003, DoCmd.OpenReport, Microsoft Access 2003, VBA, Visual Basic for Applications, WHERE statement
I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I’m baffled that it doesn’t work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const strFormName As String = “Fund Number 2″ [...]
Answer Question
| March 18, 2011 10:20 PM
Access 2003, DoCmd.OpenReport, Microsoft Access 2003, VBA, Visual Basic for Applications, WHERE statement
Resizing fields to see content in Microsoft Access 2003
In Access, to expand a field to view the field’s contents what can you press?
Answer Question
| April 2, 2009 9:43 PM
Access 2003, Microsoft Access, Microsoft Access 2003
In Access, to expand a field to view the field’s contents what can you press?
Answer Question
| April 2, 2009 9:43 PM
Access 2003, Microsoft Access, Microsoft Access 2003
Microsoft Access 2003 slow on Windows Server 2003 Enterprise
Recently one of our servers was upgraded from Windows Server 2003 Standard edition to Enterprise. We run a MsAccess2003 system on the Servewr, both backend as well as front end. Performance on the Enterprise system becomes visibly slow when process larger volumes of data at speed! Has anyone had a similar experience?
Answer Question
| November 16, 2009 10:33 PM
Access 2003, Microsoft Access 2003, VB 6, Visual Basic 6, Windows Server 2003, Windows Server 2003 Enterprise Edition
Recently one of our servers was upgraded from Windows Server 2003 Standard edition to Enterprise. We run a MsAccess2003 system on the Servewr, both backend as well as front end. Performance on the Enterprise system becomes visibly slow when process larger volumes of data at speed! Has anyone had a similar experience?
Answer Question
| November 16, 2009 10:33 PM
Access 2003, Microsoft Access 2003, VB 6, Visual Basic 6, Windows Server 2003, Windows Server 2003 Enterprise Edition
Access 2003 using IIf statement on a form
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for ‘current grade’ and a field for ‘target grade’. I also have a field ‘progress’ in which I am using an ‘IIf statement’ to compare the two fields (to [...]
Answer Question
| March 5, 2009 9:32 PM
Access 2003, Access 2003 forms, Access forms, IIF function, Microsoft Access
access 03 sending emails
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can’t get it to [...]
Answer Question
| March 2, 2009 4:31 PM
Access 2003, Access Database, Microsoft Access
Adding Serial Number to an already existing access document
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as “Auto Number” and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh
Answer Question
| March 22, 2010 2:46 PM
Access 2003, Access Database, Microsoft Access
Resizing Microsoft Access 2003 properties form
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling [...]
Answer Question
| February 23, 2009 7:32 AM
Access 2003, Access 2003 forms, Microsoft Access, Microsoft Access 2003, Microsoft Access 2003 forms, Windows XP
Temporary recordset in MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don’t need [...]
Answer Question
| February 19, 2009 6:40 PM
Access 2003, ADO, DAO, Microsoft Access, MS Access 2003, MS Access VBA
Access 2003 Form fields Sync
Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first… : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form [...]
Answer Question
| February 13, 2009 3:01 PM
Access 2003, Access 2003 forms, Microsoft Access, MS Access VBA, Office 2003
Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first… : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form [...]
Answer Question
| February 13, 2009 3:01 PM
Access 2003, Access 2003 forms, Microsoft Access, MS Access VBA, Office 2003
Changing field format in Access 2003
We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don’t need to go into now, we have to change all of them to a different format – yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of [...]
Answer Question
| January 28, 2009 8:23 PM
Access 2003, Microsoft Access, Microsoft Access forms
We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don’t need to go into now, we have to change all of them to a different format – yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of [...]
Answer Question
| January 28, 2009 8:23 PM
Access 2003, Microsoft Access, Microsoft Access forms
Vertical text in MS Access 2003 report
I’m trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle — on a slant would be nice too. When I make a label (or text box) and change the properties to [...]
Answer Question
| January 23, 2009 9:09 PM
Access 2003, Access Database Format, Microsoft Access
I’m trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle — on a slant would be nice too. When I make a label (or text box) and change the properties to [...]
Answer Question
| January 23, 2009 9:09 PM
Access 2003, Access Database Format, Microsoft Access
Linked Server Question
I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I [...]
Answer Question
| January 23, 2009 2:02 PM
Access 2003, Linked Server, Linking Access and SQL Server, Microsoft Access, SQL Server 2005
I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when I try to access it, I [...]
Answer Question
| January 23, 2009 2:02 PM
Access 2003, Linked Server, Linking Access and SQL Server, Microsoft Access, SQL Server 2005
Problem with Microsoft Access 2003 write permissions
users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.
Answer Question
| January 14, 2009 3:52 AM
Access 2003, Database write permissions, Microsoft Access 2003, Microsoft Access 2003 permissions, Microsoft Access 2003 security
users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.
Answer Question
| January 14, 2009 3:52 AM
Access 2003, Database write permissions, Microsoft Access 2003, Microsoft Access 2003 permissions, Microsoft Access 2003 security
Look at query results & pass a value to form in ACCESS 2003
I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the [...]
Answer Question
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the [...]
Answer Question
| January 8, 2009 5:05 PM
Access 2003, Access 2003 forms, Access forms, Microsoft Access
MS Access 2003 write in SQL query to convert string to numeric
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
Answer Question
| January 19, 2009 4:47 PM
Access 2003, Microsoft Access, SQL, SQL Query
How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks
Answer Question
| January 19, 2009 4:47 PM
Access 2003, Microsoft Access, SQL, SQL Query
Update database when combo box value is changed
Hello, I am wondering how to update all the text fields, other combo boxes, and memo’s when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I [...]
Answer Question
| February 20, 2009 6:27 PM
Access 2003, ComboBox, Microsoft Access
Hello, I am wondering how to update all the text fields, other combo boxes, and memo’s when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I [...]
Answer Question
| February 20, 2009 6:27 PM
Access 2003, ComboBox, Microsoft Access
Checkboxes with INSERT and DELETE actions
I’m fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:
Answer Question
| December 31, 2008 3:13 PM
Access 2003, Access forms, Microsoft Access, Visual Basic
I’m fairly novice with Access, though I know how to program in a variety of languages. I need to know how to do something in an MS Access 2003 Form. I have two tables:
Answer Question
| December 31, 2008 3:13 PM
Access 2003, Access forms, Microsoft Access, Visual Basic
