Search results

I am trying to subtract 12 hours from a time-date field when the payperiod does not equal 01. in a query I have: work date: iif([payperiod]="01",[StartTime],[starttime]-#12:00:00#) - Access added a PM before the second hash so it looks like this...

Data in my table includes the folliwing information - the sales by week are cummulative ( I cant change the way that that happens) Type, week1, week2, week3, week4 cars, 1, 3, 5, bikes, 1, 2, trikes, 0, 1, 2, 5, I need to be able to get the data for any week as examples below. Sales at...

I want to combine the two functions below into one. I want to press one button on the switchboard and If macMissing returns more than zero rows, I want to run macMissing and show the query result. If it has zero rows I want it to run macCombine. How do I modify these converted macros to do...

I need to append some rows into a table, before I add these rows i need to delete all of the old rows. I can't use a Make Table query because I am updating a linked table in another database. So how can I (automatically) delete all rows in that table before or during the append process...

I need to replace a "~" character in a spreadsheet with a "-" I have thousands of instances. I can not use search and replace? How do i do this.. I seem to remember using a search for an ASCI character but cant seem to do that either. thanks

I would like to display the following date in the format shown below it – in a query/form or report ... ITEM modified Widget1 5/15/06 Widget1 6/15/06 Widget2 3/13/05 Widget2 6/14/06 Widget2 7/23/06 Widget2 8/15/06 Widget3 3/15/05 ___________1 _____2______3_______4_______5 Widget1 5/15/05...

I am running into a problem with just one form in my database. I was getting the error 'Can't build a link between unbound forms'. After searching here and elsewhere the solution is/might be to type the linked fields into the child and master proprty fields. However when I do that I still can't...

I have 4 cascading combo boxes that filter a sub form. Everything works great up to the last selection ComboGroup4. The combo list is correct but it is not requerying the data when a selection is made in ComboGroup4. The vbas is below; please take a look at the "Private Sub...

I am trying to convert some data which is in the format: document no, number of sheets, Filename1, filename2, filename3 Where file 1,2 and 3 are the filenames of the sheets that form part of the document. I would like to change it to: document no, sheet1, filename1 document no, sheet2...

I have an Analysis_Database which reads tables and performs calculations in a Project_Database. There are multiple Project_Databases which reside together in a folder. To run my queries and analysis I link my Analysis_Database to each of the other databases and run my reports. Is there a way...

Pleae take a look at the attached database, open frmUpdate and select an item in Group1. I get a message box "Enter parameter Value" - Group1. After I click OK, sometimes I get a run-time error, usually everything works fine until the form is reopened. Can anyone see my problem. thanks Steve

If the check box is null (grey) - the default value, I do not want to include it is the sql statement. If I use the code below I get the error 94 Invalid use of null. How else can I exclude this ststement is the check box is grey. thanks If CheckStaged Then strWHERE = strWHERE & " AND...

I made (with help from this forum archive) a cascading combo box form, it all works fine except when I first select on the first combo_Group1; I get a message box "Enter parameter Value" - Group1, I leave it blank and select Ok and everything works fine, until I reopen the form. Sometimes...

How do i go about this. I want to check a box is_assigned and have field assigned_date be updated to be a date (which will be set in another period_date field). Thanks

I am trying to learn a little VBA and am stumped again... I am trying to build a SQL statement and query from an input form. I am using a book and I am not understanding or it is not explaining well. In the VBA form module I have 2 functions and then one function in a module called module 1. On...

When I try and run this function in the Immediate Window I get the Compile Error: User Defined type not defined. What did I miss Thanks Function MakeQueryDef(strSQL As String) As Boolean Dim qdf As QueryDef If strSQL = "" Then Exit Function Set qdf = CurrentDb.CreateQueryDef("qryExample")...

Attached is a database with one table of 3,304 rows. If I do a Filter by selection or filter by form for "deleted" I get 33 records. However when I do a filter for <> "deleted" I do not get 3,304-210 = 3,271 rows; I get 210 rows. What am I doing wrong. The problem appears to be that the...

Can anyone help me do this and than tell me how to see the results of the statement so i can see how the result changes when i make changes I want: zone = "08" and circuit <> "Deleted" i am using "zone='" & me.cmbzone & "'" & "AND circuit <>'" & " ' "Deleted" ' " Thanks

I have several reports in a database. I have been adding text fields to show the project name and number; however everytime I use the database for a new project i have to edit all of the reports. So I made a table with standard project details (Project number and name and location etc). In the...

I can't seem to find any answers to this maybe i am asking the wrong question, or its so easy nobody asked. I am viewing / editing some records in a form, I want to view all of the records but only allow edits to records with forms with tblData.Locked = false. How do I achieve this. thanks Steve