Search results

Ok heres one im stuggling with... I am using a sms service and trying to mass sms the mobile numbers i have stored in a table. Only problem is the sms code understands to look in a particular text box on a form for the numbers each seperated by a comma. i.e. 07979 797979, 07979 079797, etc, etc...

:confused: I have 3 identical fe be database running each with a table called cars that has identical form values just obviously different data. I want to create a table or query to display all the results from these but whenever i try and make a query i cannot seem to work it out. Anyone got...

I have just got my head around a aggregate query to count the number of results of a certain date using the search here on the forum but . . I was trying to count all dates by the day of the week? There are over 1000 dates but i was hoping for a query with 7 results showing how many on each...

I am trying to create a field that displays a count on all records which are 1 or above. I was using =Sum(IIf([financecompany]="Black Horse",1,0)) to count individual companies but i am trying to use the value field instead. I searched and found a thread using...

I think i am missing the obvious but cannot seem to get this one.... I am trying to get my form to return a value of the amount of working weeks in a month i.e. a 4 week month (like june - 4 mondays) or a 5 week month (like may - 5 mondays). i can calculate the number of full weeks using the...

This used to be an easy one. . . but has anyone noticed that long date format no longer shows the day on the end? I have looked through the regional windows settings too and i cant find it anymore. What i would like is to group some results by date on a form with it displaying the day as like a...

Does anyone know a nicer way of writing this. I basically want the form to quickly check all the fields to make sure they are filled in when the print button is clicked, different fields need to be filled in for different print buttons so i used this which works but seems very messy. Private Sub...

Does anyone know how to write a simple method of having a text box on a form default to the first day of the current month. i.e. 01/05/2005 and then a second one equalling the last day of the current month i.e. 31/05/2005? I can make it simply default to today by having the obvious =now() or...

Has anyone had any trouble with intermittent record locking when tring to open a multi user fe / be mdb. I sometimes get the message "The Microsoft Jet database engine cannot open the file "\\Office3\db\database_be.mdb'. It is already opened exclusively by another user, or you need permission...

I need to have a very simple database which can be updated from 2 countries. I would like to pick everyones brains as to the best way to do it / pros & cons on each method. So far I have FE - BE Split Database then using Office2000DevEdt Sync The BE over the Phone / Net. . . . . . .or PC...

Hi I have a report which i export to a rtf doc to be opened in word. I have found the output to in a macro to save me going through the file menu. I can see a space to save and name the doc to a specific file i.e. C:/Exports/report.rtf but it would save loads of time if this could pick from a...

Totalling A Column In A Report I have used vb to calculate unbound text boxs using i.e. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If [qandm] = "m" Then [iv] = Null If [qandm] = "q" Then [iv] = [boughtat] * 7 / 47 End Sub I cant seem to work out how to do a total at...

Hi Does anyone know how to make the new (Blank) record appear at the top of a contiuous form. I know how to requery the form to sort the entered data but it doesnt seem obvious to have a blank record at the top? Thanks in advance

Hi I have a form which contains a button to print a report. I would like to be able to have a field filled with todays date when the button is cliked to record when that report was printed. I would like it only to record a date once though so if it was cliked 3 days later it would not overwrite...