Search results for query: *

When access closes, I need to save the state (form name and screen location) of any forms that were open at the time that access was closed. I'll save the info in a table. The next time the database is opened, the forms that were last used and opened need to be opened. Any help with existing...

I have an access application that I developed for a customer. While some of the code is unqique to their application, some of it is re-usable which I use in other applications. If I turn the application over to the customer, is there a way to keep my re-usable code out of their hands? thanks

the edit flash button in dreamweaver mx 2004 is not active. I tried recreating the site cache and also removed the swf file and added it again. anyone know why this is happening? thank you.

I have a query (created in design view) where the criteria field references a control on a form such as [Forms]![frmCreateWorkOrder10]![WorkOrderID]. By default the SQL uses this with the equal operator. I need the same query, however, I need to change the operator. e.g., <, <>, etc. Any ideas...

I have a set of string contants const1 = "some string" const2 = "some other string" const3 = "etc" ... Is it possible to read the value of the variable or constant in a loop by appending the loop counter to the end of the constant name? e.g., const&[counter] example for counter = 1 to...

I need to create a checkerboard border. Either by converting a current rectangle stroke to the desired checkerboard pattern, or by creating a custom stroke. Anyone know how to do it? Please let me know if you do, or if you know of an extension that will do the trick, that would be great too...

My listbox jumps to an item that begins with the letter of the key typed, e.g., press the "b" key and the first item that begins with a "b" is selected. Type in a 2nd letter, such as "e" and the item selected is the first item that begins with "e". I want to spell a word and have the item jump...

I am suddenly getting strange problems on our live system. Several forms with unbound textboxes set the Default Value to =date(). These forms in particular are now showing #Name? in the textbox. To try and determine the cause of the problem, I created a new textbox and set default value to...

My hosting company does not provide coldfusion support. I want to leave my domain where it is but still use coldfusion. Is it possible have the non-coldfusion website reference coldfusion data located on a different domain? It doesn't seem so, but I thought I'd ask anyway. Thanks.

Two questions regarding the value stored for a lookup field. 1) Is the value of a lookup field set to null when nothing is selected from the list? 2) Assume that a record has a list id stored in the lookup field, How can I set the lookup field back to NOTHING as though a list selection was...

This multi-star problem is very perplexing to me Overview: Use a form to set beginning and ending date to supply a CROSS tab query with a date range. And use the cross tab query as the record source for a report setup to use a cross tab query. When running the query alone, the query works...

I need to change the way I'm doing things right now and need to know if PHP and MySql are the way to go for my project. I understand this isn't the MySql forum but I figure that many of you who use PHP also use MySql. I have a couple of websites that feature products. The products are...

Somehow, we lost workorder hours for 2 of our employees. We discovered that the employees were completely removed from the employees table which was linked to a labor table with cascade delete enabled. How the two employees were removed is not yet determined. The employee form's delete button...

I have a cross tab query that is used with a report. I need to sum the row of data but am not sure how to do it. The query is used for weekly time sheets for a group of employees. It is date ranged 7 days at a time and lists employee name, and hours worked for each given day within the date...

I have a function with the following line in it... Dim tdTable As tabledef I get a compile error saying "User-defined type not defined." Can someone tell me why? And what to do about it? I'm using Access 2000. Thanks a bunch.

My tblWorkOrders table has a vehicleID field which is a lookup field to the tblVehicle table. It simply associates a truck number with the work order. This is fine for a one truck per work order job. Now we are assigning multiple trucks to one job/workOrder. I created a table called...

My query includes 3 tables, tblWorkorders, tblCustomers, tblProperties. The tblCustomers and tblProperties are joined to tblWorkorders via an ID field, e.g., tblCustomers.ID joined to tblWorkOrders.customerID. Further, tblWorkOrders.customerId is a lookup field, as is tblProperties.propertyId...

I have a form that contains several fields including a start time and a stop time. The two time fields are date/time data types. I added a non-bound field to the form that holds the calculated time, e.g., timein-1-timeout. The footer of the form has a non-bound field that sums the calculated...

My application needs a report to show two things about each service that our company provides (landscape biz, services include mowing, mulching, fertilizer, etc. The report will show: The two service items are 1) Count, and 2) Man Hours. Further, I need to specify several query parameters when...

My report displays EmployeeName, Date Worked, Time-In, Time-Out. Time-In and Time-Out are stored as date/time. I created a query to pull in the necessary fields and created a TotalHours expression in the query. The TotalHours correctly performs the math on the Time-In and Time-Out fields and...