Search results

Hi there, I would like to upgrade my backend database to SQL server. Right now, Access 2003 database is stored on my local hard drive(hasn't been split yet), but I would need to put the backend on the server so that everybody else can share the same application wherever they are. The...

Hi, Is it possible to link the Access 2003 front-end to the SQL server on the backend? The database has not been split yet....but I'm just exploring my options. So for the SQL server, I am thinking of using the free one that you can simply download from Microsoft website. Is the whole...

Hi, Is it possible to link the Access 2003 front-end to the SQL server on the backend? The database has not been split yet....but I'm just exploring my options. So for the SQL server, I am thinking of using the free one that you can simply download from Microsoft website. Is the whole...

Hi, Thanks for your reply. Because I'm still at the early development stage, I have a Access version built, but as I tried to look into the future, I found myself asking those questions (i.e. who's gonna be the one keying in data down the road; will different sites use different LANs; how is...

Hi, I am trying to decide which platform to use for the purpose of this work. I need a data collection form built to collect data from hospitals. Access may be able to get the job done, given that users have the same version of access installed and have access to the same LAN, which could...

Hi, Is it possible to resize the check box in Access 2003? The box is just a bit too small for people to use. Can this be done?

Hi, I guess I can go with the Input Mask option. When exporting into Excel, will the output show the original 10-digit?

Hi, I have a field in the database that stores identifiable information. So on the form, is it possible to create some kind of "cover" to hide what's in that field? The field stores 10-digit number(however, the data type could be text-based), but I would like the field to show the content as...

Hi, Just have a question on the number of records that can be stored in an Access 2003 table. Says table size: 2 gigabyte minus the space needed for system objects. I'm using Access 2003, and what does 2 gigabyte translate into? The table stores mostly text-based data. Thanks

Hi all, Just exploring the possibility of this.... Is it possible to do an export of data directly from a form? To accomplish the same thing can be done from a report, but users would like to just do that without having to run a report. I am using Access 2003 and Excel 2003 Any...

Hi, Just thought I would get some more info from experts on this issue. I am going to split my database into front-end and back-end. The back-end will be stored on the LAN within my building; however, I would need to access the front-end from outside the building, which would require a...

Hi, I am using Access 2003. I'm creating a database and one of the fields in the database is to store Military Time. The datatype is set to "date/time", but do I need to change anything in the Format for the field to actually get it to store and show times in Military format? comment/help...

Hi, Is there a VBA code to actually close the "Find and Replace" dialogue box? something like... docmd close acruncommand find? Any comment/comments much appreciated.

Could anybody help me on this? I'm still trying to get it to work.

Hi, I'm really struggling with this adding the totals from subreports to the main report. I followed Allen Browne's example, but still getting no where. The subreport total only displays the total for the first group, but not the overall total for the subreport. can anybody hlep me on...

Hi, I'm trying to create a better form-based search by having users use the form to choose criteria. So the form would contain dropdown textboxes for users to pick. Once the selection has been made, click on a search button, and the form filters results based on what users have chosen in the...

Thank you Bob. Would it be possible to actually lock the "Look in" field on the "Find and Replace" window so it's always looking in one field after users make the change on the form? I have noticed that the "look in" field changes after users have made changes to the main form.

Hi, Does anyone know the VBA code to bring up the "search and replace" window in access 2007? something like... docmd.search and replace? comments/thougth much appreciated

Hi Bob, It did not solve the problem. I checked both the backend and the report, the memo fields are set to "rich text". I wonder if it has to do with format option. Sometimes it has a little "@" character in the format option field in table property, but I"m not sure.

Hi, I am having trouble adding the two sums together and have the two totals displayed at the top of the report. One total is from the main report, and the other total comes from the subreport. I have attached a sample test database to play around with, but i'm getting no where. I am not...