473,327 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Datasheet View Subforms - Not Allowing Data Entry

I have a subform that is searched according to a field value on the main form.

The subform has mutiple pages and each page has a subform based off a query. Today when I logged into the main form, none of the subforms that in are Datasheet view are allowing data entry. In fact, none of the rows are even visible. All I can see is the column title row for each datasheet. What does this mean? Are my queries not setup correctly? Is it an issue with allowing data entry?

This has happened before, and usually if I recreate the query, it fixes the problem. I would like to not have to do this though.

Any help would be fantastic.

Thank you.
Jun 17 '08 #1
7 3048
PianoMan64
374 Expert 256MB
Are you using a MS Access Backend or some other backend like MS SQL or Oracle?
Jun 17 '08 #2
Yes, I am using an Access Backend.
Jun 17 '08 #3
PianoMan64
374 Expert 256MB
Yes, I am using an Access Backend.
Is it split or are you running it as one file?
Jun 17 '08 #4
It is split and runs across a network.
Jun 17 '08 #5
I am still having issues w/this problem. It seems now that while the database is in use on another computer, it does not work correctly on any others. On some computers, the subform is disappearing altogether. Is this a problem w/the way my backend is setup?

Thanks.
Jun 23 '08 #6
missinglinq
3,532 Expert 2GB
It is split and runs across a network.
Does this mean the back end is on a server on the network and the front ends are on each user's PC? Or are the users sharing a front end that's also on the network? Sharing a front end can cause this type of problem as well as many others, including repeated corruption.

Linq ;0)>
Jun 23 '08 #7
The backend is saved on a shared drive on the network. Each user has an individual front in that is saved on their personal computer.

I was forced by my employer to build a database for our team, and it's been a difficult road - figuring out everything. WIthout this board, I'd be totally lost.


Does this mean the back end is on a server on the network and the front ends are on each user's PC? Or are the users sharing a front end that's also on the network? Sharing a front end can cause this type of problem as well as many others, including repeated corruption.

Linq ;0)>
Jun 24 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Georges Heinesch | last post by:
Hi: I have a tables in relationship to each other. When I open the main table (table 1), I see a "+" at the very left of every record. Clicking on the "+" expands the data of the linked table...
13
by: Aladdin | last post by:
I have an MS Access form on which I have a listbox listing tables in that database. I want to be able to click on any of those tables and view its contents on the same form using subforms or any...
1
by: Knud Rogilds | last post by:
I have tried everything, what am I doing wrong? I have a data entry form in datasheet view (for mass data entry). One of the fields are SalesID, and I would like to use DLookup to populate an...
4
by: danit58 | last post by:
Is it possible format the backcolor of rows, depending the value in a field of the the rekords, in datasheet mode?? Can you help me???
3
by: Thelma Lubkin | last post by:
I'm resubmitting a question that went unanswered a while ago. I'll try to rephrase it. I have a hierarchical form that presents data on an 'organization'. It has 2 subforms, the first a...
5
by: Bill | last post by:
This database has no forms. I am viewing an Access table in datasheet view. I'd like to execute a macro to execute a function (using "runcode"). In the function, I'll reading data from the record...
1
by: ppwlee | last post by:
Hi, I have created a main form with 2 subforms, Both subforms are in datasheet view. I want to be able to pick a record from subform1 and the corresponding linked record (created by a...
14
by: BASSPU03 | last post by:
(I'm using Access 2003 on a Windows XP O/S.) I've gotta present an update on my database this week--possibly within the next 24 hours. A solution or guidance to this inquiry would really, really...
5
by: Deano | last post by:
I have five subforms each living in a page on a tab control. Each form is in datasheet view. The time has come to resize both the forms and the subforms. I am able to change the column widths...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.