Search results

Hey. I want to create a loop which runs through all records in a table, to compare the data it finds with the data entered. What I've got is a time field, and when a value is entered, I want it to run through every record in the table, and check if the time entered is between the time of two...

I'm using a tab box on a form, and want to use the OnClick event of the tab buttons along the top. I have the option of the OnClick event, but no matter what the code is behind, it won't run!!! Why not? It's really annoying me Thanks

Is there a way to requery all the controls or types of controls? I've tried doing a form.requery and others, but the only one that works is the specify the control each time, which sucks,cos i'd have to do it for 366 controls which I don't really want to do. Thanks

Whenever I click into a list box and select an item, it changes all of the text box controls to " #Error " The text box controls have a control source of the following: =Format("3/1/"+[cboYear].[Text],"dddd")+" 3rd" But slightly different for each one. Why when I click in the list box to...

Could anyone point me in the right direction with this please? I'm looking at creating an event calendar form, where as I can type in the date of the event, the time, whether it is all day, or specify the start and finish time of the event, and whatever I enter, it checks current events and...

I have a table which stores all transactions performed on a bank account. I've now created a table which allows the user to enter in any transactions that will occur on a monthly basis, and the day number that they occur on. What I want, is some code that will check the table for any that are...

I'm looking at creating an automated system to install the database. I know that with the access developer kit it includes an installer package creator, however it doesn't have some features I'm after. Basically, I want it to obviously copy the database file into a folder (that the user...

How do I check if another computer is on? Basically the back end is going to be stored on a computer (no server involved. Small P2P network) and it obviously needs to be on for everyone to access it. Is there a way of checking if that computer is on first before doing anything else? I can...

StrSQL = "INSERT INTO LV (Directory_Name:,Filename:, Total_Files,Total_Records:,Total_Batches:, Total_YH) VALUES ('" & DirectoryName & "', '" & FileName & "', TotalFiles , TotalRecords , TotalBatches , TotalYH);" Have tried loads of combinations of the " ' and ' " to get it working but just...

How do I pull a value from a certain column of a list box? I want to retrieve the ID number from the ID column of a list box, but have no idea how. Please help. Thanks

I've got an error handler to obviously check for and error, however it is saying there's an error when there isn't one. I've got one very large IF statement running with others in it. Outside the if statement is the error command to go to the function of what to do on an error, which is outside...

How do you control the position of a form programmatically?

For records that have an image (such as members of staff having a picture for each one) what is the best method for displaying this picture on the form? Currently I've got an image box which is updated with the file location reference stored in the table. it work well, however, in order for the...

Can anyone see why this code is causing access to hang EVERY time I TRY and run it. It doesn't even run at all, just hangs outright. i = -1000 Do Until i = 1000 Do Until Bar.Left = 5.529 Bar.Left = Bar.Left + 0.001 Loop Do Until Bar.Width = 0 Bar.Width = Bar.Width - 0.001 Loop...

For some reason the form will not delete the record. I've tried two versions of the record delete function each one failing. By using DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70 DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70 It simply does nothing, but by using...

I'm trying to use a split form so that it shows normal controls and a datasheet. I'm able to do this easily on a normal form, but it isn't working on a subform. Is it not supposed to, or is there just some proper way of doing it? Thanks

Is there a way to find the properties of a field in a table through VB? I'm looking to find the datatype of a specific field in a table or query to run different code depending on the data type? Thanks

I've got the following code to ask the user what criteria they want to use for generating an SQL string which is then used to generate a custom report. Now it does work and registers what the user types in, however, all it does when it opens the report is bring up another input box with what I...

Hiya. I was wondering if anyone could help with the code needed the edit the caption of the labels and the source of the text boxes on a report, when they are being taken from a multi select list box. Thanks

I'm able to create my report (although it only opens in design view) and i've found the CreateReportControl method to add fields and things I need, but I do I use them both? Dim rpt As Report Set rpt = CreateReport DoCmd.Restore That Is the code I'm using to create the report, and I already...