Search results for query: *

It’s been several days that I am trying to have this work. Came close several times to end up where data could not be entered in the last subform. My problem is in # 3 and my other problem is lack of experience. The goal is to 1 Select a client in a drop down (works well) 2 Create a record...

Hi all, Despite several combinations of form/subforms, I am unable to achieve the following and I am asking for guidance and ideas to achieve this functionality. Background A group of customer is created by the user, each group has a unique ID ([group_id]) and a group has several Customers...

Hi all. I have 3 fields in a table [ccan]= Client number [amount]= in $$ [div]= Division For each CCAN, I need to select the Division where the amount is the largest using Access 2003 visual interface. I simply cannot achieve the desired results as either the data is not selected or the...

Hi all Something weird is happening. The validation rule of a field [audit_physical_date] in a form is as follow >=Format([prepost_date],'Short Date') or Is Null (the Format command is required to transform a MM/DD/YYYY HH:MM field in Short Date. The input mask of the field [physical_date] is...

Hi all I have been requested to add conditional 'reminders' to users when data is entered in a form with a query rowsource. Most of them were simple but I am stuck with this one. I hope you can help me identifying the correct syntax or let me know of another possibility. I have separated each...

Hi, How can I have the format of these exported fields to excel to have a phone format (000) 000-0000. The data is stored in the database as 0000000000. I have changed the format of the cells in the excel template with the result that when the user enters the data directly, the formatting...

Hi all, This is my 1st select query in VBA.. The data returned will ALWAYS be only ONE record and the data will be used to populate a new excel spreadsheet generated from an excel template (.xlt). My problem is that I get the error Cannot Execute a Select Query. Can someone point me in the...

Hi all The Business Unit has requested that I include US Addresses in a specific client table. In teh corresponding form, I have added the 2 digit US codes for the states to the tbl_provinceand a lookup to determine which country that province/state is. All works well However the postal...

Hi all, I have read as much as I could and I am still confused, so I am turning to the experts of this board. I have a form [frm_cst] that is populated by a query [qry_cst]. Record selection is made by the user through a combobox [cmb_cst] with a RowSource [qry_cmb_cst] with the [ccan] field...

I am trying to let the user hide a variable number of rows in a protected spreadsheet. I could create a macro that would unprotect and hide the rows selected however the problem is that the user cannot select rows while the sheet is protected.. Any way around that? If I did not say it...

Hi all I have a form [frmasset]with a subform [frmsubasset] frmasset shows a combo box, save/exit command button, few fields while the frmsubasset shows several other fields in a datasheet When I try to set the tab order on frmasset, only the subform shows up... I never had that problem...

Access 2003, front-back end format. I have a form 'location_info' populated from table 'tbl_location'. The table has an autonumber [loc_#] and a index (multiple) [ccan] What I require is that everytime a new location is created under a ccan the [loc_name] be populated with: The...

I have been trying to improve the speed of my database by implementing a Persistent Connection as per my post thread705-1524118 where PHV (great thanks) provided help. In order for the persistent connection to work, Ineed to keep this form open hit INvisible. I have been trying several ways...

I have an access 2003 front end back end setup used by 4-5 users. Each user has a front end on their desktop and the back end resides in the commany's shared drive with a folder dedicated to the back end. My problem is that if more than 1 user is using the dtabase, the forms can take more than...

Hi all In a form, i need to store the inputs of 2 combo box to be critarias in a query. From what I know, I will have to Dim 2 variables (one for each combo), then refer to these variables in the query. Private Sub frm_rpt_onClick () On Error goto ErrorHandler Dim cmbone as String Dim...

Access 2003, frontend/back end configuration My goal is to issue a new report (report header, page header etc..) for each group. Data is as follow: [audit_no] Selected by the user in a drop down [asset_no] Several assets for each audit [3rd_party] Each asset may or may not have a 3rd party...

I have an Access 2003 front end and back end. I did not use the utility to split the database as I setup the ends fron day one. My question is as follow: I know that the back end must be in a 'shared' mode but what about the front ends that each user has in their own desktops? Should the...

Access 2003: Front end - back end' The opening menu displays the version number of the front end in a text box with the following code ="Version Number ... " & Nz(DLookUp("[ver_clt]","[tbl_version_client]"),"????") There is always only one record in that table. In my attempts to fix a...

I have a front end - back end database in testing now and when ever there are more than one user on the database, everything is very slow. I am in the process of following the 100 tips to accelerate a database found on this forum and I have a question to reduce the number of lines of code. On...

I have looked at post regarding audomatic front end update. http://www.tek-tips.com/viewthread.cfm?qid=30072 http://www.tek-tips.com/viewthread.cfm?qid=884708 I also looked in databasejournal.com but the info is also quite old and for '97 However all are above my programming experience with...